Use IsError.

If IsError(Range("ssn")) = True Then
MsgBox ("NAME N=na()OT FOUND!!!!")
Exit Sub
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"vbidiot"
wrote in message
...

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