| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Line in Header Text
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatentate text and insert blank line | Excel Worksheet Functions | |||
| wrap text inserts a padding blank line | New Users to Excel | |||
| Text File Import leaves a blank row after each line | Setting up and Configuration of Excel | |||
| Unwanted blank line in cell with wrapped text | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Linear Mode
