I have the following and it works for any row that starts with the word "Complete". What do I need to do to also include deleting rows that start with "801730-TECH-YEG-" ?
Code:
Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A65536").End(xlUp))
Do
Set c = SrchRng.Find("*Complete*", LookIn:=xlValues)
If Not c Is Nothing Then c.EntireRow.Delete
Loop While Not c Is Nothing