Haeder/Footer param

[Erik Creyghton]

One can insert variables like &File or &Date in a header/footer description.
I tried to pick up a reference to a cell in the header/footer and did not
succeed.
Is there a trick to do this ?
Regards,
Erik

 

[Tom Ogilvy]

You can build the footer string using VBA in the beforeprint event. In that
case, you would do

Activesheet.PageSetup.LeftFooter = _
"formatting string " & ActiveSheet.Range("B9").Text & " more formatting
string"

 

[Frank Kabel]

Hi
can be done only with VBA. e.g.

with activesheet
.pagesetup.centerfoort=.range("A1").value
end with

 

[Erik Creyghton]

Thanks for the answers. This will work fine.
Erik

 

[Gord Dibben]

Erik

You will have to do this using VBA.

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

Gord Dibben Excel MVP