smithgt
Board Regular
- Joined
- Jan 22, 2010
- Messages
- 193
I've recored a Macro. I'm filtering a column and I want to hide values (rows) where the values = 0.
The recored macro has done the opposite, by only displaying values selected - see below. The problem will be when I run this on another sheet that doesn't have values matching this list.
How do I add a filter to hide zero values?
thanks
The recored macro has done the opposite, by only displaying values selected - see below. The problem will be when I run this on another sheet that doesn't have values matching this list.
ActiveSheet.Range("$A$1:$N$6837").AutoFilter Field:=14, Criteria1:=Array( _<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
"0.3", "0.4", "0.67", "1", "1.16", "10.5", "100", "1000", "10000", "1007.79", "109", "119" _<o></o>
, "119.15", "12000", "125", "1300", "13000", "144", "1500", "153", "157.62", "159.82", _<o></o>
"166.8", "169.02", "17.25", "176.25", "181.65", "193.36", "2.01", "20", "200", "2000", _<o></o>
"201", "211.39", "226", "226.54", "229.89", "232", "240", "243.22", "249.93", "25", "250" _<o></o>
, "2500", "25000", "258", "262.65", "2625", "270.43", "2750", "298.04", "298.73", "3.01", _<o></o>
"300", "3000", "314.8", "325", "3360", "342", "343.65", "35", "350", "3500", "360", "3600" _<o></o>
, "363", "368.06", "370", "374", "3750", "39.64", "40", "400", "4000", "40000", "42.73", _<o></o>
"4250", "450", "50", "500", "5000", "540", "5625", "57.61", "6", "600", "612.5", "62", "64" _<o></o>
, "700", "720", "73.53", "74", "74.3", "74.51", "75", "75.89", "750", "7500", "762.37", _<o></o>
"788", "800", "8000", "861.21", "87", "90", "9000", "932.86", "98"), Operator:= _<o></o>
xlFilterValues
How do I add a filter to hide zero values?
thanks