Header/footer

[KWhamill]

is it possible to display the ONLY the year in the Header/footer? if any body
knows that would be great

 

[Dave Peterson]

You could type it in.

Or you could use a macro...

Option Explicit
Sub testme01()
With Worksheets("Sheet1")
.PageSetup.CenterHeader = Year(Date)
'any more stuff
End With
End Sub

 

[Gord Dibben]

Why not just type 2010 in a custom footer?

You cannot format &Date without using VBA

Sub YearInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "yyyy")
End With
End Sub


Gord Dibben MS Excel MVP