Thread: [Solved] AutoFilter Criteria3
View Single Post
 
Old 01-17-2013, 01:06 PM
coxjamd coxjamd is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jan 2012
Posts: 6
coxjamd is on a distinguished road
Default 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
Reply With Quote