print cells at the top

[Guest]

I've posted this question but i havent seen an answer. ive been told this
group has the smartest and brightest people

i am trying to have excel print cells a1:m10 at the top of each page that is
printed. i can't use the page setup... header because some of the cells in
that range refer to another sheet. i also can't use the "print titles" in
sheet because i only want that range of cells and not the entire row/column
to appear on each printed page.

is there a macro or non-macro solution to have ONLY that range of cells
appear in every page that is printed in the sheet? the sheet extends over
multiple pages and the number of pages the sheet has varies from report to
report

thanks in advance for any help.

 

[Bill Kuunders]

The print titles option only prints the rows as far as the underlying print
area.
So if your normal print area spans columns a to m your print titles will
also only show the required area
A1 to m10
Send me a file if that still wouldn't work and I'll have a look.