Header Font

[jesmin]

Hi:
Happy new year. I have created an Excel report. In its center header I put a text. Now how can I change the font size of this text in center header to 12.
I am bolding the text at the same time. I tried in VBA something like:

dim mystr = "Monthly Report"
With Activesheet
.pagesetup.centerheader = "&B" & mystr
..........code to change font

End with

Thanks in advance

[wjohnson]

Go to Menu - Select FILE - PAGE SETUP - CUSTOM HEADER - type in what you want. There should be some icons directly above the "LEFT - RIGHT - CENTER" section boxes - select your text then select the "A" icon and follow the directions.