Hi,

Am Fri, 14 Feb 2014 05:34:47 -0800 (PST) schrieb :

Hello i would like to make Auto Filter Macro which will always remove "0" and word "test" and will leave rest of things.
ActiveSheet.Range("$E$10:$F$21").AutoFilter Field:=2, Criteria1:=Array("1", _
"2", "3", "4" ... dont want to write here tons of things just say which i dont want), Operator:=xlFilterValues
End Sub

try:

ActiveSheet.Range("$E$10:$F$50").AutoFilter Field:=2, Criteria1:="<0",
_
Operator:=xlAnd, Criteria2:="<test"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2