Create a two-line header programmatically
 

Hi:

Can anyone tell me how to create a two-line header for a worksheet using
vba? I have a client who wants a data-specific date range in the header as
well as the company name. I want to put this in two lines in the header.
Currently the dates are inserted in the VBA code. Both the company name and
the dates should in the center header. Any help would be greatly
appreciated.

JJ

Create a two-line header programmatically
 

As an example:

ActiveSheet.PageSetup.CenterHeader = "ABCD" & vbcr & "EFGH"

--
Regards,
Tom Ogilvy


"Jeanne Conroy" wrote in message
...
Hi:

Can anyone tell me how to create a two-line header for a worksheet using
vba? I have a client who wants a data-specific date range in the header
as
well as the company name. I want to put this in two lines in the header.
Currently the dates are inserted in the VBA code. Both the company name
and
the dates should in the center header. Any help would be greatly
appreciated.

JJ