| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW-TO: programmatically create SAS length statement | Excel Discussion (Misc queries) | |||
| Programmatically create combo boxes | Excel Programming | |||
| how to create a user form programmatically | Excel Programming | |||
| help with create spreadsheet programmatically | Excel Programming | |||
| How to create picklists programmatically | Excel Programming | |||
Linear Mode
