Setting different rows to repeat for print.
 

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

Setting different rows to repeat for print.
 

You'll need multiple print sessions, changing settings between each one.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"katie" wrote in message
...
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).

Setting different rows to repeat for print.
 

Hello,

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

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


HTH,
JP

On Oct 19, 6:58 am, katie wrote:
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).