How to format text with a Macro?

LeedMe 6 Posts Tuesday March 28, 2017Registration date April 12, 2018 Last seen - Nov 14, 2017 at 12:03 PM
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
See more