i want to write an error statement but it's not working for me.
The code below works when the cell value equals #n/a BUT it screws up
my macro when the the cell value doesn't equal #n/a. I'm getting an
error 13...
I tried to use an error 13 statement but no such luck either. Here's my
code below.


Code:
--------------------

If Range("ssn") = CVErr(xlErrNA) Then
MsgBox ("NAME NOT FOUND!!!!")
Exit Sub
End If
--------------------


--
vbidiot
------------------------------------------------------------------------
vbidiot's Profile: http://www.excelforum.com/member.php...o&userid=31582
View this thread: http://www.excelforum.com/showthread...hreadid=515319