cell reference in a footnote

Question

Is there a way to enter a cell reference in a footnote so the footnote will display the content of the referenced cell?

Answer 1

Excel does not do "footnotes" so I assume you mean "footer" as in headers and footers when printing.

You can reference the value in a cell if you use VBA

Sub CellInFooter()

    With ActiveSheet

        .PageSetup.CenterFooter = .Range("A1").Value

    End With

End Sub

On second thought you can enter text in a Comment then have the Comment print at bottom of page.

I guess that could be considered as footnote.

Gord

Answer 2

You're welcome.

Thanks for the feedback and good on you for doing the VBA research.

Gord

Answer 3

You were correct...I meant "footer" and your help was exactly what I needed.  I'd never used VBA nor macros in EXCEL, but found good tutorials and with your VBA coding help it was exactly what I needed.....Thanks much for your response.