Elena,

Try something like

ActiveSheet.PageSetup.CenterHeader = "Line One" & Chr(10) & "Line
Two"


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



"Elena" wrote in message
...
Thanks to Chip's help, I have the code to set up a header on my
Excel
Worksheet:

CDRLWs.PageSetup.LeftHeader = "CDRL: " & ComboBox2.Text & " DID
No.: N/A"

Yet, I was wondering if there was a way to put a line break in
the middle.

I would like my left header to look like this (currently, it
is on one line):

CDRL: A001
DID No.: N/A

Is there a way to set this up properly?

Thanks in Advance,
Elena