May 15 2023 02:21 PM
I have a single worksheet that I need to print 150 pages of with sequential numbering pages in the header.
For example:
Truckload #1 - first page
Truckload #2 - 2nd page
etc.
I cannot figure out how to get them to change with each print.
Please advise!
Camille
May 15 2023 02:45 PM
If a macro would be acceptable:
Sub PrintPages()
Dim i As Long
For i = 1 To 150
Range("A1").Value = "Truckload #" & i
ActiveSheet.PrintOut
Next i
End Sub
You can change the cell and the text as needed.
May 16 2023 10:19 AM
Thank you for replying. It 'sounds' like a good way to do that IF I wasn't juvenile in my Excel knowledge and knew what or how to do a macro!! LOL
Thanks though! I will just have to do it old school.
Camille
May 16 2023 10:54 AM
If you feel adventurous:
May 16 2023 10:55 AM
May 16 2023 02:53 PM
Great instructions. Easy to follow... except it is giving me this error. ??
I have copy & pasted, and I have entered in myself. Same error.
May 16 2023 02:58 PM