Get Unique Items

This is simplicity itself.

This is the classic description of the difference between a collection and an array.

The process is:-

Read your range into an Array if it is a list it is probably a single array

create a new collection

read each member of your array into the collection.

The collection requires an address and an entry

if you use the entry as its address then each duplicate entry will overwrite its predecessor.


Now read the collection into a new array and save back to excel.

In your case, read every entry of your collection into a text variable

Display the text variable using a message box.

Sounds Long Winded but the bulk of the work has been done for you.

Please Login or Register  to view this content.

You can also try this...
Getting Uniques
Function syntax is UniqueCol(Range_Arr)

Please Login or Register  to view this content.

Regards,