Header/footer


K

KWhamill

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

Advertisements

D

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top