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

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"

--
Regards,
Tom Ogilvy



"Erik Creyghton" wrote in message
...
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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Erik Creyghton wrote:
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

Thanks for the answers. This will work fine.
Erik

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

On Tue, 27 Jul 2004 21:08:00 +0200, "Erik Creyghton"
wrote:

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