ClearContents if #VALUE! found in cell

[clr]

Hi All........

This code works fine for a text string as "oldest", but I want it to work if
the cell value is #VALUE! (basically, clear or delete the row is the #VALUE!
error is found)

Dim oldest As String
oldest = Range("data!k1").Value 'value is a text string
With Sheets("ALL12")
lastrow = .Cells(.Rows.Count, "a").End(xlUp).Row
For r = lastrow To 12 Step -1

If .Cells(r, "b").Value Like oldest Then
.Rows(r).EntireRow.ClearContents
End If
Next r
End With

Any help would be much appreciated.......

Vaya con Dios,
Chuck

 

[Jacob Skaria]

Try

If .Cells(r, "b").Text = "#VALUE!" Then

 

[clr]

How cool it is!..........works perfect!
You are a Prince, kind Sir...........thank you very much.

Vaya con Dios,
Chuck, CABGx3