Haeder/Footer param

E

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
 
T

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"
 
F

Frank Kabel

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

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

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
 
Top