Blank Line in Header Text

[S. S.]

When setting up a header using a VB macro, how does one
include a blank line?

Worksheets("Master").PageSetup.CenterHeader = "Text on
Line One" & "Text on Line Two"

I know this does not put the text on two separate lines.
What magical code will help?

Thanks

S.

 

[Chip Pearson]

Try something like

Worksheets("Master").PageSetup.CenterHeader = "Line 1" & vbCrLf &
"Line 2"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com