Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fetch Autofilter options
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fetch Autofilter options
the option dropdowns in autofilter are not accessible using VBA. You can
create your own unique list with code or you can use the Advance filter to produce a unique list to another location on the sheet. here is sample code that performs the function: http://www.j-walk.com/ss/excel/tips/tip47.htm -- regards, Tom Ogilvy "ashish128" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete options for AutoFilter? | Excel Worksheet Functions | |||
Get Autofilter options (VBA) | Excel Discussion (Misc queries) | |||
viewing data in autofilter options. | Excel Discussion (Misc queries) | |||
Autofilter Options | Excel Discussion (Misc queries) | |||
Autofilter list options | Excel Discussion (Misc queries) |