Actually, I can use the advanced filter. I can get the a unique list from a named range and put it on a separate worksheet. Then I'll have the list I want. BUT! I want to skip the intermediate step.
I was hoping to have the autofilter setup so that I programmatically retrieve (and populate...
Using VBA, I need to retrieve the list of items(?) from an Excel autofilter drop-down list. With this, I will programatically select from and set the criteria..
For instance, if I am autofiltering a list where team names are in the filtered column, I want to get the list of teams that are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.