Repeat row from page 'x' on where x is not the first page

[gdude1976]

Is there a way to print a row along the top of each page, with the
exception of the first page?

Specifically, I would like my repeating row to begin on the third page.





Thank-you.

 

[CyberTaz]

One option - although there may be others more elegant...

Keep the content for pages 1 & 2 on one sheet, put the content for pages 3+
on another sheet. In File>Page Setup - Sheet, specify the appropriate Row to
Repeat at Top. Click the one sheet tab, shift-click the other sheet tab &
see if Print Preview shows you what you want to see.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Is there a way to print a row along the top of each page, with the
exception of the first page?

Specifically, I would like my repeating row to begin on the third page.

One way:

Public Sub MySpecialPrint()
With Sheets("Main")
.PageSetup.PrintTitleRows = vbNullString
.PrintOut From:=1, To:=2
.PageSetup.PrintTitleRows = "$1:$1"
.PrintOut From:=3
End With
End Sub