| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel List specific data from a list? NOT Autofilter?? | Excel Discussion (Misc queries) | |||
| Question about a unique list in VBA by checking data inside of 2 columns | Excel Discussion (Misc queries) | |||
| List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
| Making a list inside a cell | New Users to Excel | |||
| How to create a List inside a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
