Forum Discussion

camille922's avatar
camille922
Copper Contributor
May 15, 2023

Excel header/page #

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...
excel
HansVogelaar's avatar
HansVogelaar
MVP
May 15, 2023

camille922 

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.

Resources