Excel 2003 Multi Criteria filter in VBA

[alexduy]

Hi Excel Experts,

I wrote the following code to filter out blanks and zeros in my worksheet. The macro works perfectly when using excel 2010, however, it does not work with Excel 2003 because of this line. It's because Excel 2003 doesn't let you filter multiple criteria. Is it possible to modify the code to filter multiple criteria using excel 2003?


Selection.AutoFilter Field:=2, Criteria1:="=$0.00", _
Operator:=xlOr, Criteria2:="="

Please Login or Register  to view this content.

[AlphaFrog]

Tested with Excel 2003

Please Login or Register  to view this content.

[alexduy]

Thank you so much!

[alexduy]

Hi AlphaFrog,

The code you gave me work perfectly with the previous worksheet, however, when I tried to using the same code with another data table, it does not work. I added a third criterion and the macro breaks. I've attached another worksheet. Could you please help me modified the code? Thank you very much, I appreciate your help.

.AutoFilter Field:=1, Criteria1:="=System:", _
Operator:=xlOr, Criteria2:="Services", _
Operator:=xlOr, Criteria3:="Inactive"

Please Login or Register  to view this content.