ClearContents if #VALUE! found in cell

C

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
 
C

clr

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

Vaya con Dios,
Chuck, CABGx3
 

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

Top