L
Lo456
Is it possible to have a formula in a header/footer or is it just for text?
Thanks!
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
S
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
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
L
Lo456
Thanks!!!
Gord Dibben said: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