Type Mismatch error using IF

[SBF12345]

Greetings,

I am receiving a type mismatch error in the code below:

If Cells(b, "A").Value = "" Then        Rows(b).Delete
        End If

I understand the problem more or less, but am stumped as to find a simple solution.

As I understand it if the property or variable is not of the correct type then its going to cause the mismatch error.

I am receiving the error when the contents of the cell being compared to "" is "#VALUE!"

I would like to be able to filter for any and all types of things without the risk of a mismatch.

Ideally I would be able to write something like:

If Cells(b, "A").Value = "" or "#VALUE!" or "N/A" Then
Rows(b).Delete
End If

 

[Dryver14]

If Cells("A" & b).Value = "" Or Cells("A" & b).Value = "#Value" Or Cells("A" & b).Value = "N/A" Then
    Cells("A" & b).EntireRow.Delete
End If

 

[Marcelo Branco]

Maybe...

If IsError(Cells(b, "A")) Then
    'do something
ElseIf Cells(b, "A") = "" Then
    'do something
End If

M.

 

[SBF12345]

Got it running, Thanks!