print certain cells at the top of each page
 

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 sheets and the number of pages the sheet has varies from report to
report

thanks in advance for any help.

Karim Hemani

print certain cells at the top of each page
 

correction:

"the sheet extends over multiple PAGES and the number of pages the sheet has
varies from report to report"

Thanks!

"karimhemani" wrote:

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 sheets and the number of pages the sheet has varies from report to
report

thanks in advance for any help.

Karim Hemani