Setting different rows to repeat for print.

K

katie

I have a worksheet with 3/4 pages and require one row of headings on first 3
pages and different row on subsequent pages, is this possible? (As far as I
can see alas, I think you can only set one row to repeat).
 
J

JP

Hello,

You can set the "rows to repeat at top" programmatically like this:

ActiveSheet.PageSetup.PrintTitleRows = "$1:$1"


HTH,
JP
 
Top