Header/Footer Formula?

[Lo456]

Is it possible to have a formula in a header/footer or is it just for text?
Thanks!

 

[Gord Dibben]

Text only but via VBA you can write the results of a formula to the
Header/Footer

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

Where A1 contains a formula.


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

Just text. However, you can use a Workbook_BeforePrint() procedure to do a
calculation and put it in the Header or Footer:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
'your calculation code here
End Sub

 

[Lo456]

Thanks!!!

Text only but via VBA you can write the results of a formula to the
Header/Footer

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

Where A1 contains a formula.


Gord Dibben MS Excel MVP