Repeat Title Row every Page

[Kavy]

Does anyone know how to using excel vb repeat a row of a worksheet at the top of a page, ever page?
Thanks

 

[Scott Huish]

So the row you want to repeat is the value in insrow or is it the value of insrow+1?

If insrow is 0, do you want any rows to repeat at the top?

 

[Kavy]

the row i would like to repeat is insrow + 9.
if insrow = 0 then the row the needs to repeat every printed page is 9

Thanks for your help on this, sorry for all the confusin

 

[Scott Huish]

ActiveSheet.PageSetup.PrintTitleRows = Rows(insrow + 9).Address

 

[Kavy]

ah thank you very much, may i ask what the .address does?

 

[Scott Huish]

It returns the address of the range as a string

so the address of Rows(9) for example would be $9:$9

 

[Kavy]

thanks