This message shows on cell while moving cursor over to it:

"Moving or deleting cells caused an invalid cell reference, or functio
is returning reference error"

and in cell, value is somewhat like this: "#REF!"

In my vba automation program due to this it halts on this point wit
END or DEBUG message box.

I need to detect this type of value to display error msgbox instea
halting with debug.

In my activesheet, detect this type of value containing in cell

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=39553