Is it possible to have a formula in a header/footer or is it just for text?
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

On Mon, 16 Mar 2009 12:39:03 -0700, Lo456
wrote:

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lo456" wrote:

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

Thanks!!!

"Gord Dibben" wrote:

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

On Mon, 16 Mar 2009 12:39:03 -0700, Lo456
wrote:

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