Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get Autofilter options (VBA)
Hi to all,
I didnt knew what to type to search and therefore am posting this request. Whenever we autofilter a range and select any field then we get a dropdown list of unique entries in that field. 1. If there is only one item then how to get that. eg. A 5 5 5 5 If I autofilter on column A then it will only contain 5. How can I get this value using VBA 2. how to get all of the the autofilter options? eg. A 1 2 3 1 2 3 1 2 3 if I autofilter on column A then the available options will be A 1 2 3 howto get them using VBA. Kindly advice. With Regards Ashish Sharma |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
viewing data in autofilter options. | Excel Discussion (Misc queries) | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Autofilter Options | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Autofilter list options | Excel Discussion (Misc queries) |