Get the list of data inside AutoFilter list

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 :
 
T

Tom Ogilvy

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.
 
Top