Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With the current year entered in A1,
Sub CellValueInHeader() With ActiveSheet.PageSetup .LeftHeader = Range("a1").Value & " Results" End With End Sub Vaya con Dios, Chuck, CABGx3 "Hubitron2000" wrote: I want my header to say "yyyy results", where yyyy is the current year. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
How do I display the RESULT of a formula | New Users to Excel | |||
Amount or Numbers in Words | New Users to Excel | |||
Spellnumber | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |