Report

How to format text with a Macro?

Ask a question LeedMe 3Posts Tuesday March 28, 2017Registration date November 14, 2017 Last seen
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!