Setting different rows to repeat for print.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
Hello,

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

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


HTH,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row to repeat while printing 3
Printing: rows repeating across the top 1
Repeat different rows on top 2
Print Titles: Repeating both left column and top rows 2
Repeating Rows - Exception 1
Repeat Rows at Top - Except Final Page 2
Hide repeating row 1 7
Repeat printing rows in multiple worksheets 19

Back
Top