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.