Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- For i = 2 To access.UsedRange.Rows.Count
- If access.Cells(i, 11) = "LOW" Or "TBD" Then
- Rows(i).delete
- Exit For
- End If
- Next i
- If access.Cells(i, 11) = "LOW" Or access.Cells(i, 11) = "TBD" Then
- With access.Cells(i, 11)
- If .Value2 = "LOW" Or .Value2 = "TBD" Then Rows(i).Delete
- End With
Add Comment
Please, Sign In to add comment