Header/Footer Formula?
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!
|