Footer-Can I insert the value of a cell (text) in a 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

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" <[email protected]>
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