Eliminate Duplicates from an Array / Only Original Names

[RS15]

Good morning everyone!

I have an array in VBA, Ary1 (1 to 30, 1 to 1). It contains a list of names, some of which repeat multiple times. I want to take this list and only using VBA, and not entering the list into the spreadsheet, I want to eliminate all duplicate values from the array. So if there were say 10 original names in that list that only those would be left in the array (It can also be a new array if that is easier, I just need an array with only the original names).

I have attached a spreadsheet that shows what I want to do. In column A I have the list of names, column B has the list of names with all the duplicates eliminated and replaced with blanks, and column C has only the original names. I want to avoid using a spreadsheet for this if possible. Please let me know if you have any ideas or suggestions. Thanks so much.

Example.xls

[patel45]

select the range then Data, Duplicate remove

[RS15]

I understand how to do this. I am trying to do this in VBA though. The excel spreadsheet was just an example of what I am trying to do in VBA. Thanks.

[nilem]

Hi Rs15,
maybe so

Please Login or Register  to view this content.

[RS15]

You are amazing!! Is there any way that you could give me a brief explanation as to what is going on here or point me in the right direction. There is some VBA here that I haven't ever seen before. Thanks!

[nilem]

You can find it here or in the many-many posts on this forum.