This is very helpful. Thank you very much Alan!

"Alan Beban" wrote:

Magnivy wrote:
Hello,

I have a macro that writes values from cells into an array. Is it possible
to delete repetitive values from the array or create another array that would
only have different values?

Any help on how to accomplish the above would be greatly appreciated.

Thank You!

Magnivy


If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

arr2=ArrayUniques(arr1) will do it.

Use of the ArrayUniques will require that there be an effective
reference to Microsoft Scripting Runtime.

Alan Beban