Thread: Row Delete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Van Doug Van is offline
external usenet poster
 
Posts: 17
Default 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