Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard code date in header
Hi,
I am using Excel 2003. I would like to hard code the date in a header so that once the file is saved that the date doesn't change when the file is open a day or week later. How would I have to change the following to do that. I'm relatively new at this programming stuff so your help would be greatly appreciated. Range("A4").Select With ActiveSheet.PageSetup .PrintTitleRows = "$1:$3" .PrintTitleColumns = "" End With With ActiveSheet.PageSetup .CenterHeader = "DSV - " & "&A" & Chr(10) & "Statement as of " & "&D" End With TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard code date in header
Hi
..CenterHeader = "DSV - " & "&A" & Chr(10) & "Statement as of " & Date Hopes this helps. --- Per "Jan" skrev i meddelelsen ... Hi, I am using Excel 2003. I would like to hard code the date in a header so that once the file is saved that the date doesn't change when the file is open a day or week later. How would I have to change the following to do that. I'm relatively new at this programming stuff so your help would be greatly appreciated. Range("A4").Select With ActiveSheet.PageSetup .PrintTitleRows = "$1:$3" .PrintTitleColumns = "" End With With ActiveSheet.PageSetup .CenterHeader = "DSV - " & "&A" & Chr(10) & "Statement as of " & "&D" End With TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to do a countif - want cells that are before or on a certain dateand do not want to hard code that date | Excel Worksheet Functions | |||
Hard code date in excel . . . | Excel Discussion (Misc queries) | |||
Hard return in textbox for header text | Excel Programming | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Not Hard Code If | Excel Discussion (Misc queries) |