Cell Content as Header?
 

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

And if so, HOW!?

Thanks
Alex


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569830

Cell Content as Header?
 

Lets 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

--
Gary''s Student


"alex3867" wrote:


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

And if so, HOW!?

Thanks
Alex


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569830

Cell Content as Header?
 

Many thanks Gary''s Student!

:)


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=569830