AutoFilter rows when multiple columns are 0 in VBA

Asked Feb 13 '20 at 22:51

Active Feb 13 '20 at 23:11

Viewed 37 times

I'm trying to filter out values when both column B and C are equal to 0 on the same row. When using the following code, rows are filtered out when either column, not both simultaneously, are equal to 0.

With Sheets("Recon").Range("$A$1:$L$2500")
    .AutoFilter Field:=Array(2, 3), Criteria1:="<>0"
End With

edited Feb 13 '20 at 23:11

BigBen

46,229
7
24
40

asked Feb 13 '20 at 22:51

Rycro

1

You can make a helper column and then just filter on that – urdearboy Feb 13 '20 at 22:57
1

check out https://stackoverflow.com/questions/28575754/filter-out-multiple-criteria-using-excel-vba – Bobby Heyer Feb 14 '20 at 00:05

AutoFilter rows when multiple columns are 0 in VBA

0 Answers0