deleting rows containing specific text in 2 columns

[amitmk]

I am using the AutoFilter code to delete rows wherever a cell in column "E" contains specific text "FILM" .. How do I change this if I want to delete rows which contains "SERIAL" in column E AND contains "ABC" in column L (Need to avoid the loop mode as that takes too long with approx 200,000 rows)


Code which I need to change -

With ActiveSheet
.AutoFilterMode = False
With Range("e1", Range("e" & Rows.Count).End(xlUp))
.AutoFilter 1, "*FILM*"
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With

 

[Fluff]

Hi, welcome to MrExcel
Give this a go

With ActiveSheet
    .AutoFilterMode = False
    With Range("A1:L" & Range("E" & Rows.Count).End(xlUp).Row)
        .AutoFilter 5, "SERIAL"
        .AutoFilter 12, "ABC"
        On Error Resume Next
        .Offset(1).SpecialCells(12).EntireRow.Delete
        On Error GoTo 0
    End With
    .AutoFilterMode = False
End With

 

[amitmk]

Thanks a ton Fluff. This sorts my life

 

[Fluff]

Glad to help & thanks for the feedback