Repeat dynamic rows when printing

[rowena345]

I have searched internet but cannot seem to find any solution. Can anyone help please?

In my project I need to calculate some data and put them into a table underneath some graphs and print the whole sheet including the graphs and the table. The number of the graphs may vary so the position of the table may vary too. For example sometimes the table starts at row 117, sometimes it starts at 182, or some other row. The table can be big so will need to be printed in more than one page, so I want to set up the table so that the top two rows of the table will repeat on the pages that contain the table. I know something like below will repeat rows but in my case the rows need to be dynamic. Can anyone tell me how to do it?

With ActiveSheet.PageSetup
.PrintTitleRows = "$184:$185"
.PrintTitleColumns = ""
End With

Thanks in advance for any help!

Rowena

[rowena345]

I've found the solution:

With ActiveSheet.PageSetup
.PrintTitleRows = Range(Cells(lr + 2, 1), Cells(lr + 3, 1)).EntireRow.Address
.PrintTitleColumns = ""
End With

From here: http://www.ozgrid.com/forum/showthread.php?t=78502