Delete duplicates within an array in vba Excel -

i've got values inside array , delete values double entries, e.g. have eur,eur,eur,gbp,yen , remove double euro entries within removing them execel spreadsheet.

just save in array. new array should that: eur,gbp,yen

after write them spreadsheet.

my code far:

dim arraycurrency variant rangestart = "e2" rangeend = "e" rangenew = rangestart & ":" & rangeend & lrow currencyarray = range(rangenew).value  each element in currencyarray  next element 

i hope can me!

best regards matthias

use dictionary object unique values - in future.

for current case, may use removeduplicates method on range.