Excel Header formatting with a programmed field

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
 
T

Tim Williams

With ActiveSheet.PageSetup
.CenterHeader = "&""Arial,Bold""&20" & Format(Range("A2"), "mmmm
yyyy")
End With

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Range name in Header 1
ActiveSheet header including a named range 2
Formatted Date in header applied with a macro 6
Help with Header 2
Using named range value during Workbook_BeforePrint event 1
Formatting from CopyFromRecordset 0
Apply cell formatting using VBA 1
Problem with date formatting 5

Top