Remove unnecessary values in array's cells

[yaelzi]

Hi,


In my code I created an array of 20 cells.

Each cell contains values that can repeat themselves like:

Anna, John, Ron, Anna, Ron, Jake


I want to change each cell to be without the duplicate values:

Anna, John, ROn, Jake


Can you please advise?


Thanks

 

[vijaySharma]

Yalezi,


Welcome to Chandorg forums.


Do have a look at http://www.cpearson.com/excel/VBAArrays.htm


HTH

~VijaySharma