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