Excel Header formatting with a programmed field

  • Thread starter Thread starter Bob Reynolds
  • Start date Start date
B

Bob Reynolds

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
 
With ActiveSheet.PageSetup
.CenterHeader = "&""Arial,Bold""&20" & Format(Range("A2"), "mmmm
yyyy")
End With

Tim
 
Back
Top