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?
Let me know, many thanksCode: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"
SJ




Reply With Quote