Header - Print range on top of each page?

[TTom]

I want two print Range("A1:O2") as a header on each of my printed pages.
All pages print Columns A:O; however, I may adjust rows per printed page.

I tried using 'custom header' from menu options, but this doesn't seem to allow a range entry?
I looked at Excel help and did not find an answer.

Any suggestions? Thanks :wink:
TTom

 

[agihcam]

Hi -
how about File > PageSetup > Sheet > Rows to repeat at top.

 

[TTom]

Perfect. I did that a long time ago. Your reply jogged my memory on the how to do.
Thanks, TTom