Row Delete
This is similar to the "Is this Possible?" post.
I want to delete a record that meets a certain condition.
This works with the first condition, but anything after the "or" won't
delete.
y = 5
Do While Range("A" & y) < ""
If Range("F" & y).Value = "957-TYPE" Or _
Range("F" & y).Value = "149-DUPLICATE" Then
Range("F" & y).EntireRow.Delete
End If
y = y + 1
Loop
|