help on erasing duplicates in array

[sugee]

I add all values in column 6 in to an array than add them in to comboBox. The problem is there are lots of same values and I could'nt remove the duplicates.
I 'm sending the files can you help me pls?

My code is in module 2 and in userForm! button click ..

[sugee]

Here is my code,
RemoveDuplicatesInArray don't work

Please Login or Register  to view this content.

[nilem]

Hi Sugee,
this is just an example (author of the code ZVI), I deleted the unwanted data from your file