Type Mismatch Error on IF conditional
 

I have to do a Vlookup on a previous day's sheet to find matching names and then delete the rows with the ones that match, leaving only the new names. I've tried labeling matches as "old" and new ones as "new", but I'm still trying to get it to work without relabeling the results. Currently, the new ones show up as #N/A errors, and the matches list the matching names. This is what I've got so far:

This works until it finds a #N/A, and then it gives me a type mismatch error. I'm assuming this occurs because it's an error instead of a value, but I'm not sure how to fix it. Any help is appreciated!

Type Mismatch Error on IF conditional
 

hi KeriM,

If Not IsError(Cells(i, "C").Value) Then

--
isabelle



Le 2012-09-19 10:11, KeriM a écrit :
I have to do a Vlookup on a previous day's sheet to find matching names
and then delete the rows with the ones that match, leaving only the new
names. I've tried labeling matches as "old" and new ones as "new", but
I'm still trying to get it to work without relabeling the results.
Currently, the new ones show up as #N/A errors, and the matches list the
matching names. This is what I've got so far:


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


Last = Cells(Rows.Count, "C").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "C").Value) < xlErrNA Then
Cells(i, "A").EntireRow.Delete
End If


--------------------


This works until it finds a #N/A, and then it gives me a type mismatch
error. I'm assuming this occurs because it's an error instead of a
value, but I'm not sure how to fix it. Any help is appreciated!

That works perfectly! Thanks Isabelle!

Type Mismatch Error on IF conditional
 

you're welcome! ..feedback is always appreciated!

--
isabelle


Le 2012-09-20 11:06, KeriM a écrit :
isabelle;1605675 Wrote:
hi KeriM,

If Not IsError(Cells(i, "C").Value) Then



That works perfectly! Thanks Isabelle!