Thursday, October 5, 2023

Export multiple records one by one from Excel

 

Sub Print1()

    For a = 1 To 10

        Sheet3.Range("L2").Value = a

ActiveWindow.SelectedSheets.PrintOut copies:=1, collate:=True, IgnorePrintAreas:=False

Next

End Sub

No comments:

Post a Comment

Reset Ubuntu with factory reset & and reinstall

  Try configuring unconfigured packages: sudo dpkg --configure -a Update the contents of the repositories sudo apt-get update Try to fix mis...