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).
 
You'll need multiple print sessions, changing settings between each one.
 
Hello,

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

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


HTH,
JP
 
You must log in or register to reply here.

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