View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Reynolds[_4_] Bob Reynolds[_4_] is offline
external usenet poster
 
Posts: 3
Default Excel Header formatting with a programmed field

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