How to define specific cells as header and footer for printing?

  • Thread starter Thread starter serdar
  • Start date Start date
Serdar,

I think you're confusing "Rows to repeat at top" with the custom header,
both in File - Page Setup. Rows defined as rows to repeat at top only
appear at the top of the printed page. For stuff to appear at the bottom of
every page, you can use the custom footer. You can't link it to cells in
the sheet, but a macro can put cell contents into the custom footer.
 
I just thought this repeating rows fits my goal but it seems not now.
I can only use range of cells as footer by macros, right? I am helping a
friend and he does not have a good VB knowledge so he cannot use macros.
Well that's ok i help him writing a macro if he insists on. Thanks.
 
Serdar,
I can only use range of cells as footer by macros, right?
Click to expand...

Yes. The macro would have to actually put the cell contents into the
footer; Excel has no provision for putting cells in the footer. Rows to
repeat at top puts rows at the top of the page, below the page header.

ActiveSheet.PageSetup.CenterFooter = Range("A1")
 
Back
Top