Get cell content when it contains Error

[plans]

Hi,
I need a macro to display in a Message Box the content of a cell when it has the error #Name?.
For example, if the cell contains the text =Area/2 but because there is no Area range defined, than I will get the #Name? error, so in this case I would like to have that Message Box display the content of the cell: =Area/2

Thanks in advance

[karedog]

Maybe :

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.