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