Where is this typed into?..... the Header or some other place?
I tried putting it into the header and it returned what I typed.
Thanks,
Dennis

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Thu, 18 Oct 2007 03:50:02 -0700, Smudge
wrote:

Hi everyone,

Is it possible to use a cell reference in the custom header to pick up info
in a cell in the worksheet?

TIA