mikecroom
New Member
- Joined
- Oct 8, 2010
- Messages
- 47
I have set up some VBA to set up a table with auto-filters (excel 2007)
Now I want to access the list of possible values for one of the columns - as shown in the drop-down when you set the filter manually.
Is there an object which provides this? I can't find one. I am looking under .AutoFilter.Filters
Or do I need to access the range and calculate the unique values myself?
Mike
Now I want to access the list of possible values for one of the columns - as shown in the drop-down when you set the filter manually.
Is there an object which provides this? I can't find one. I am looking under .AutoFilter.Filters
Or do I need to access the range and calculate the unique values myself?
Mike