Create a two-line header programmatically

  • Thread starter Thread starter Jeanne Conroy
  • Start date Start date
J

Jeanne Conroy

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
 
As an example:

ActiveSheet.PageSetup.CenterHeader = "ABCD" & vbcr & "EFGH"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
msAccess Report Header export to Excel 3
Macro for Dates 5
Change Header/Footer w/ Worksheet Option Buttons 1
Copy Range of data using VBA 0
Find string from column A in Range("B2:F7") list the header of that column/s 5
Post my named ranges in column A 10
How to hide password? 1

Back
Top