Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to fill a 2 column ListBox with unique items obtained from
Advanced Data Filter. Here is the code that puts my Advanced Data Filter results on the worksheet: Range("MyRange").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range _ ("CritRange"), CopyToRange:=Range("ExtractRange"), Unique:=True I would like those results to be displayed directly in a 2 column ListBox, without having to display them first on the worksheet. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Advanced filter does not effect data list | Excel Discussion (Misc queries) | |||
Extracting results of Advanced Filter. | Excel Programming | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
Need to Search Column then Paste Data at end of Row? Advanced Filter? | Excel Programming | |||
refresh advanced filter results | Excel Discussion (Misc queries) |