Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Properties
Hi All
I am interested in discovering how I can access the autofilter object-properties (if at all?). I'll explain what I am trying to do.. If I set an autofilter on a worksheet with a column of related text, the drop-down appears in which the unique list of values in that column appears. Is there an object or property I can access from VBA for that list? In a similar vain, if I set a filter on the first column, any other columns autofilter drop down list is restricted to values for that column based on the rows selected by the first filter. Again I wish to access this list from VBA. TIA Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |