Cell Content as Header?

A

alex3867

IS it possible to use the content of a particular cell as the
header/footer?

And if so, HOW!?

Thanks
Alex
 
G

Gary''s Student

Let’s say we want to use the content of cell Z100 in the center header:

Create a BeforePrint event macro containing the following line:
ActiveSheet.PageSetup.CenterHeader = Range("Z100").Value

To understand event macros, see:

http://www.cpearson.com/excel/events.htm
 
Top