Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Footer
Can I insert the value of a cell (text) in a footer.
I want the footer to update automatically if the value of teh cell changes. For example, if cell A3 on Sheet 1 = "Test" I want to use this text in all my footers in the other tabs in my worksheet. Any suggestions would be much appreciated. Pjotr |
#2
|
|||
|
|||
Pjotr
Sub Cell_in_Footer() Set wkbktodo = ActiveWorkbook For Each ws In wkbktodo.Worksheets With ws .PageSetup.RightFooter = Sheets("Sheet1").Range("A3").Text End With Next ws End Sub Gord Dibben Excel MVP On Tue, 12 Apr 2005 14:14:15 -0700, "Pjotr" wrote: Can I insert the value of a cell (text) in a footer. I want the footer to update automatically if the value of teh cell changes. For example, if cell A3 on Sheet 1 = "Test" I want to use this text in all my footers in the other tabs in my worksheet. Any suggestions would be much appreciated. Pjotr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions | |||
Inserting Footer - Ajit | Excel Discussion (Misc queries) | |||
How to automate custom footer on all tabs | Excel Discussion (Misc queries) | |||
Formatting a footer with a top border-line | Excel Discussion (Misc queries) | |||
Date in Footer | Excel Worksheet Functions |