![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Join Date: Mar 2002
Posts: 155
|
Hi,
I am trying to figure out spacing when writing VBA for a Custom Header. For instance, in the code below, how would I modify it so that "Schedule" is the first line of the header and "As Of" is the second line of the header? ----------------------------------------------------------------- Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = "Schedule As Of" End Sub ----------------------------------------------------------------- Thanks in advance, MikeL Using XL2000 |
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|