I have a worksheet that has over 1500 rows and I want to delete the row if it contains "I24" it does delete them but I have to run the macro multiple times. What can I do to my code to so I can just run it once?
For Each cell In Range("F1:F2000")
If cell.Value = "I24" Then
cell.EntireRow.Delete
End If
Next cell
For Each cell In Range("F1:F2000")
If cell.Value = "I24" Then
cell.EntireRow.Delete
End If
Next cell