[RESOLVED] Autofilter Criteria limitation / error

[Siddharth Rout]

Guys,

I am trying to filter on more than 2 sets of criteria but am unable to make the code work, is the code wrong or have I breached the limitation of the filter property?

Selection.AutoFilter Field:=16, Criteria1:="=CN", Operator:=xlOr, _
        Criteria2:="=HK", Operator:=xlOr, _
        criteria3:="=ID", Operator:=xlOr, _
        criteria4:="=IN", Operator:=xlOr, _
        criteria5:="=PK", Operator:=xlOr, _
        criteria6:="=TH", Operator:=xlOr, _
        criteria7:="=TW"

Let me know, many thanks

SJ

On one field you can only use 2 criterias. Have you checked the "Filter by using advanced criteria" option which is also known as "Advanced filter"? you can check it out under Data->Filter->Advanced Filter

The Advanced Filter command can filter a range in place like the AutoFilter command, but it does not display drop-down lists for the columns. Instead, you type the criteria you want to filter by in a separate criteria range above the range. A criteria range allows for more complex criteria to be filtered.