Link cell text to header
 

Is there a way to have the text in a cell be linked so that it appears
in the header? Then if the text in the cell is changed, the header
changes accordingly?


--
Beeblebrox
------------------------------------------------------------------------
Beeblebrox's Profile: http://www.excelforum.com/member.php...o&userid=37348
View this thread: http://www.excelforum.com/showthread...hreadid=571825

Link cell text to 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



--
Gary''s Student


"Beeblebrox" wrote:


Is there a way to have the text in a cell be linked so that it appears
in the header? Then if the text in the cell is changed, the header
changes accordingly?


--
Beeblebrox
------------------------------------------------------------------------
Beeblebrox's Profile: http://www.excelforum.com/member.php...o&userid=37348
View this thread: http://www.excelforum.com/showthread...hreadid=571825

Link cell text to header
 

Do you mean a worksheets header? If so, no.

You could use the beforeprint event to place the desired information in the
header.

http://www.cpearson.com/excel/events.htm for an overview of events.

--
Regards,
Tom Ogilvy


"Beeblebrox" wrote:


Is there a way to have the text in a cell be linked so that it appears
in the header? Then if the text in the cell is changed, the header
changes accordingly?


--
Beeblebrox
------------------------------------------------------------------------
Beeblebrox's Profile: http://www.excelforum.com/member.php...o&userid=37348
View this thread: http://www.excelforum.com/showthread...hreadid=571825

Link cell text to header
 

I already had a print macro that hid some columns and set a print area.
So just before the code setting the print area I used the following and
it works.



With ActiveSheet.PageSetup
CenterHeader = Range("N3").Value
RightHeader = Range("N5").Value
End With


--
Beeblebrox
------------------------------------------------------------------------
Beeblebrox's Profile: http://www.excelforum.com/member.php...o&userid=37348
View this thread: http://www.excelforum.com/showthread...hreadid=571825

Link cell text to header
 

This macro works, however I cannot get my header to process the format,
to bold the header.
"&B" is not working into the macro.

Any suggestions?
Thanks.


Beeblebrox wrote:
I already had a print macro that hid some columns and set a print area.
So just before the code setting the print area I used the following and
it works.



With ActiveSheet.PageSetup
CenterHeader = Range("N3").Value
RightHeader = Range("N5").Value
End With


--
Beeblebrox
------------------------------------------------------------------------
Beeblebrox's Profile: http://www.excelforum.com/member.php...o&userid=37348
View this thread: http://www.excelforum.com/showthread...hreadid=571825