How can i reference a cell in the footer/header?
Posted by hansoh on January 08, 2002 11:33 AM
in a print out, i would like the footer to have date, time, and in addition, the value in a certain cell in a worksheet. for example, let's say the activesheet's value in A1 is 'Jack Smith'.
thanks in advance.
-han
Posted by hansoh on January 08, 2002 11:42 AM
got it. thanks anyways. code for anyone who's interested...
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup.LeftFooter = Sheets("put me in footer").Range("$e$55")
End With
End Sub
