Microsoft Office Forums - View Single Post - How to auto-delete rows that contain specific word?

jeffreybrown · 10-14-2018, 02:52 PM

You would need to use some VBA for this. Something like this where email addresses are in column D

Code:

Sub FilterDelete()
    With Range("D1", Range("D" & Rows.Count).End(xlUp))
        .AutoFilter Field:=1, Criteria1:="*@maildrop.com"
        .Offset(1).EntireRow.Delete
        .AutoFilter
    End With
End Sub

Note: Please first test on a copy of your data