![]() |
#1
|
|||
|
|||
![]()
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 |
Tags |
autofilter, criteria3 |
|