I have searched the forum for a couple of days and have not quite found an answer to this question or maybe I did and didn't understand it (I am a ultra noob), but I am looking to write code to filter out rows that contain certain words in them. The code I am using is
ActiveSheet.Range("$A$1", "$Q" & CLastRow).CurrentRegion.AutoFilter Field:=11, Criteria1:=Array("<>*Crew Rest*", "<>*Leather*", "<>*Curtain*", "<>*Pocket*"), Operator:=xlAnd
Using this, it only filters out the last criteria value. What am I doing wrong or is there another way to do it? XL2007
ActiveSheet.Range("$A$1", "$Q" & CLastRow).CurrentRegion.AutoFilter Field:=11, Criteria1:=Array("<>*Crew Rest*", "<>*Leather*", "<>*Curtain*", "<>*Pocket*"), Operator:=xlAnd
Using this, it only filters out the last criteria value. What am I doing wrong or is there another way to do it? XL2007