Autofilter: How to actually apply a filter?

Topics: Developer Forum
Sep 21, 2010 at 10:26 PM

i successfully applied the autofilter property to a range of data, and the generated excel shows the value dropdowns. what i'm now looking for is how to actually use the autofilter. i.e. for example in a column containing rows with values "Y" and "N", i'd like to change the autofilter selection so that only rows containing "Y" are shown instead of all rows.