Filter using vba - exclude more than three criteria

[thomsonreuters]

Hi Experts,

i want to DO auto filter without following text "CN", "KR", DE", "EP", :GB", "JP", "US", "WO", "FR" USING vba SCRIPT....i tried with below code but it does not work....Please could anyone help on this...

Selection.AutoFilter Field:=5, Criteria1:="<>CN", Criteria2:="<>KR", Criteria3:="<>DE", Criteria4:="<>EP", Criteria5:="<>GB", Criteria6:="<>JP", Criteria7:="<>US", Criteria8:="<>WO", Criteria9:="<>FR", Operator:=xlFilterValues


Thanks
JP

 

[Fluff]

You are limited to two criteria, unless doing an exact match.
You could put a formula in a blank column that returns (for example) True or False depending on whether the row should be visible or not & filter on that.

 

[thomsonreuters]

You are limited to two criteria, unless doing an exact match.
You could put a formula in a blank column that returns (for example) True or False depending on whether the row should be visible or not & filter on that.

Thanks much.

JP

 

[Fluff]

My pleasure.