Type Mismatch Error on IF conditional

K

KeriM

I have to do a Vlookup on a previous day's sheet to find matching name
and then delete the rows with the ones that match, leaving only the ne
names. I've tried labeling matches as "old" and new ones as "new", bu
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 th
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 mismatc
error. I'm assuming this occurs because it's an error instead of
value, but I'm not sure how to fix it. Any help is appreciated
 
I

isabelle

hi KeriM,

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

--
isabelle



Le 2012-09-19 10:11, KeriM a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 13 : type mismatch 2
Sheet to sheet code Type Mismatch 6
type mismatch error in macro in excel 0
Type Mismatch 3
Cdbl and Cstr with a "Type Mismatch" Error 6
type mismatch error 3
Macro to delete row if cells greater than certain value 1
VBA - exporting serial letters to single documents 0

Top