Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Reference in Header
Is there a way to reference a specific worksheet cell in the header?
Thanks |
#2
|
|||
|
|||
Dave
Macro.......... Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("A1").text End With End Sub Alternative........ Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.CenterFooter = .Range("A1").Text End With End Sub Gord Dibben Excel MVP On Fri, 20 May 2005 11:38:05 -0700, "Dave" wrote: Is there a way to reference a specific worksheet cell in the header? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
Cell reference manipulation | Excel Discussion (Misc queries) | |||
Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions |