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

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

--
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
>
>

Many thanks Gary''s Student!