Hi:
Happy new year. I have created an Excel report. In its center header
put a text. Now how can I change the font size of this text in cente
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 advanc