How to format text with a Macro?

[Closed]
Report
Posts
6
Registration date
Tuesday March 28, 2017
Status
Member
Last seen
April 12, 2018
-
I have a simple event based "macro" that populates my header with information.
The question I had was:
How can I have the header populate this information at a set bold font size of 26??

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then ActiveSheet.PageSetup.CenterHeader = "RETURNS TO DATE: $" & ActiveSheet.Range("E1")

End Sub

Thank You

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!