Cell Content as Header?

[alex3867]

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

And if so, HOW!?

Thanks
Alex

 

[Guest]

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

 

[alex3867]

Many thanks Gary''s Student!