Hi
I'm having a bad day today
I want to delete rows where column V contains a variable text
I normally use
For i = Selection.Rows.Count To 1 Step -1
If Cells(i, 22).Value = "???????" Then ' the question marks are what I want to remove
Cells(i, 22).EntireRow.Delete
End If
Next i
What I actually want to do is remove any rows where the data in column V starts with HS-
cheers
Paul
I'm having a bad day today
I want to delete rows where column V contains a variable text
I normally use
For i = Selection.Rows.Count To 1 Step -1
If Cells(i, 22).Value = "???????" Then ' the question marks are what I want to remove
Cells(i, 22).EntireRow.Delete
End If
Next i
What I actually want to do is remove any rows where the data in column V starts with HS-
cheers
Paul