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
|