Hi Tom,
I tried but the size does not change. Maybe it is because the header text is
written in macros. I have to write it in macros because it writes to
different dates which change according to the data in worksheet. I just want
something like this:
ActiveSheet.PageSetup.CenterHeader.font.size = 16
Any sugestions?
Thanks
"Tom Ogilvy" wrote:

You can do it manually, so turn on the macro recorder and do it manually.
Then turn off the macro recorder and look at the recorded code.

--
Regards,
Tom Ogilvy


"ermeko" wrote in message
...
Hi,
Is it possible to specify font size for PageHeader inside Macros?
ActiveSheet.PageSetup.CenterHeader = "good afternoon"