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!
Type Mismatch Error on IF conditional
Similar Threads
Threaded Mode
