Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

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

got it. thanks anyways. code for anyone who's interested...

Posted by hansoh on January 08, 2002 11:42 AM

Private Sub Workbook_BeforePrint(Cancel As Boolean)

With ActiveSheet.PageSetup.LeftFooter = Sheets("put me in footer").Range("$e$55")

End With

End Sub

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.