Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with AutoFilter macro
Hello i would like to make Auto Filter Macro which will always remove "0" and word "test" and will leave rest of things.
I dont want to write all Criterial "numbers like 5,6,3,17, because that things will grow endless, just always Remove "0" and "test" word from Filter. (Tabele 1) 1 2 3 4 0 5 6 7 892 11 18 0 18 221 3 43 0 54 6 71 test 11 18 202 18 221 404 1223 --------------------------------------------------------------------------- Sub Elipse() ' 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 Thanks for any help Jena C. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with AutoFilter macro
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with AutoFilter macro
W dniu piątek, 14 lutego 2014 14:34:47 UTC+1 użytkownik napisał:
Hello i would like to make Auto Filter Macro which will always remove "0" and word "test" and will leave rest of things. I dont want to write all Criterial "numbers like 5,6,3,17, because that things will grow endless, just always Remove "0" and "test" word from Filter.. (Tabele 1) 1 2 3 4 0 5 6 7 892 11 18 0 18 221 3 43 0 54 6 71 test 11 18 202 18 221 404 1223 --------------------------------------------------------------------------- Sub Elipse() ' 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 Thanks for any help Jena C. WOW ! THANK YOU Claus :)!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro, AutoFilter... | Excel Discussion (Misc queries) | |||
Problems using autofilter | Excel Discussion (Misc queries) | |||
Autofilter problems in Excel 2003 | Excel Discussion (Misc queries) | |||
problems w solution 4 enable AutoFilter for a protected worksheet | Excel Programming | |||
autofilter/cell selection problems | Excel Programming |