Thread: Blank Line in Header Text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Blank Line in Header Text
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



"S. S." wrote in message
...
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.


Reply With QuoteReply With Quote