Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using autofilter in VBA
Hello,
I would like to know if it is possible copy the data in excel column to a variable using the autofilter. I have a huge amount of data repeated in a column, like: 18189 18189 18189 18189 18189 ... 18190 18190 18190 18190 18190 ... 18191 18191 ... And I just want the single data, without repetition, like: 18189 18190 18191 ... I know that it could be done with a "for" cicle, but it takes a lot of time running, because the excel sheet have around of 60 000 lines of data. So, the autofilter gives me the data without repetition right? can I get access to that data and save them to a variable? Thanks so much for helping. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |