Get the list of data inside AutoFilter list

  • Thread starter Thread starter ashleyyeung
  • Start date Start date
A

ashleyyeung

Hi All,

How can I get the list of data inside the AutoFilter?

Or is there any function provided by VBA to distinct (like SQL
distinct from database) a column of data?

Thanks a lot.

Ashley :
 
You can get this information from using the Advanced filter, using the
unique checkbox in the dialog. You can have Excel copy this list to a new
location.

You can't access the autofilter list directly.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remembering the same filtering criteria 13
Autofilter problem 7
AutoFilter-criteria with VBA in XL07 4
count visible cells after autofilter 1
Autofilter based on user inputbox 3
Autofilter in a macro 1
SELECTING AN ITEM FROM AUTO FILTER ! 2
cycling through all the possible criteria in an autofilter column 2

Back
Top