Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel97 How can I refer to a cell in the Header?
- Thread starter BarryG
- Start date
I've used tip from:<br>
<A HREF=" TARGET="_new"><br>
Sub UpdateHeader<br>
Worksheets(1).PageSetup.LeftFooter = "Your static text " & Worksheets(1).Cells(1, 1).Value &" static text continues"<br>
End Sub<br>
<br>
With this you can build headers/footers you want. There's also a method to run this macro automatically before printing.<br>
<br>
Good luck,<br>
Al<br>
<br>
<A HREF=" TARGET="_new"><br>
Sub UpdateHeader<br>
Worksheets(1).PageSetup.LeftFooter = "Your static text " & Worksheets(1).Cells(1, 1).Value &" static text continues"<br>
End Sub<br>
<br>
With this you can build headers/footers you want. There's also a method to run this macro automatically before printing.<br>
<br>
Good luck,<br>
Al<br>
<br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question