error code help

[vbidiot]

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

 

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[vbidiot]

I was trying to use the ISerror but I was screwing it up royally!
Thank you sir for the quick reply. Hopefully I can help you someday...I
doubt I will be able to...but you never know