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?

On further research it appears that AutoFilter will only filter by 2 criteria. I have a sheet with multiple variables in Column "A". I need to filter out the criteria being less than 03-003 AND not containing "x" and not containing "Pending". Moving some data to another column to be filtered is not an option. This is a live document where rows are regularly being added so I am not sure how an array can help. Any ideas?

If you need more than 2 criteria on the same column then your immediate choices are:

• Use a helper column
• Use the advanced filter instead of an autofilter. Using the advanced filter will require a criteria range to be set up.

__________________
Colin

RAD Excel Blog