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!