Excel Header formatting with a programmed field
With ActiveSheet.PageSetup
.CenterHeader = "&""Arial,Bold""&20" & Format(Range("A2"), "mmmm
yyyy")
End With
Tim
"Bob Reynolds" wrote in message
...
Hello, I have the following in my code:
.RightHeader = Format(Range("A2"), "mmmm yyyy")
This returns me the Date and Year in A2. My problem
How can I set this to be at Arial Bold 16pt?
It now defaults to the standard each time I run it.
Thanks
Bob Reynolds
|