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!