pattern = "Invoice" 'search for string pattern
Set source = Range("A1:A10") 'rows to examine
For i = source.Cells.Count To 1 Step -1
If InStr(source.Cells(i).Value, pattern) = 0 Then 'does not match pattern
source.Cells(i).EntireRow.Delete
End If
Next i