AutoFilter Criteria3
I am trying to run an Autofilter using multiple criteria. I have no issue with Criteria2, but when I try to enter AutoFilter Criteria3 I end up with a runtime error.
Code that works for 2:
Selection.AutoFilter Field:=1, Criteria1:=">03-003", Operator:=xlAnd, _
Criteria2:="<>*x*"
Trying to enter for 3:
Selection.AutoFilter Field:=1, Criteria1:=">03-003", Operator:=xlAnd, _
Criteria2:="<>*x*", Operator:=xlAnd, Criteria3:="<>Pending"
Am I missing something simple?
Last edited by coxjamd; 01-17-2013 at 01:15 PM.
Reason: typo for Criteria3
|