When you're creating a custom header or footer in Excel, you can enter the
page numbers, tab names, file names, dates and all manner of other
automatically calculated data. Sometimes, however, you want to set up your
headers so that the header includes a snippet of information that is on the
worksheet somewhere. It would be great if you could specify a cell reference
on the current worksheet in a custom header or footer for that worksheet.

Is this for the wish list or are you asking how it can be done?

Wish list is here.........

http://register.microsoft.com/mswish/suggestion.asp

Macro is here............

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").text
End With
End Sub


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 11:55:01 -0800, "Suegi123"
wrote:

When you're creating a custom header or footer in Excel, you can enter the
page numbers, tab names, file names, dates and all manner of other
automatically calculated data. Sometimes, however, you want to set up your
headers so that the header includes a snippet of information that is on the
worksheet somewhere. It would be great if you could specify a cell reference
on the current worksheet in a custom header or footer for that worksheet.