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?

Code:
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