Cell Reference in Footer 1

[ck1999]

Is there a way to set up a footer to reference the value in a cell? For example if cell c3 is an employees name, can excel print this name in the footer of all the sheets to print?

Thanks

Chris

 

[AnotherHiggins]

You cannot do this without VBA (a macro).

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[ck1999]

thanks

 

[AnotherHiggins]

In case you are curious about how to do it:

ActiveSheet.PageSetup.Leftfooter = Range("A1").Value

(Or Rightfooter or Centerfooter)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.