Get the list of data inside AutoFilter list
 

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 :

--
Message posted from http://www.ExcelForum.com

Get the list of data inside AutoFilter list
 

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.

--
Regards,
Tom Ogilvy

"ashleyyeung " wrote in message
...
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 :)


---
Message posted from http://www.ExcelForum.com/