Can Excel headers automatically look to a cell for data? &[B2]

[Guest]

Using MS Office Excel 2003 SP2. Created a crew calender that shows each
week's crew schedule on a seperate tab. Each worksheet shows days Sunday
through Saturday as the column's top cell. The date is shown in the second
cell of each column. I wanted Sunday's date to show in the header for each
sheet that is printed out. I tried &[B2]. Is what I'm attempting even
possible?

 

[Gord Dibben]

Possible through VBA

Sub CellInFooter()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
ws.PageSetup.CenterFooter = ws.Range("A2").Value
Next
End Sub


Gord Dibben MS Excel MVP