AutoFilter Selection info

[bstubbs]

I'm interested in getting autoFilter information using VBA. When you have autoFilter turned on for a column, no matter how many rows of data are within the column, clicking on the autoFilter icon will give you a listing of the unique entries within the column and in sorted order. It is that information that I'm trying to extract. Can anyone give me a vba idea on how I might do that?

TIA.

Bob

[HSV]

Hi Bob,

What you want to do with it I don't know, but put your names or numbers in column A. Run the code.
Test it once if this is what you mean.

Please Login or Register  to view this content.

Much easier code.

Please Login or Register  to view this content.

[bstubbs]

Harry:

Thanks. The code works fine but I'm was hoping for code that would look at the autoFilter object to do exactly the same thing. Any ideas in that direction?

[HSV]

I have no idea Bob what you mean.... sorry.
Maybe other helpers do.