Delete duplicates within an array in vba Excel

Question

I've got values inside an array and I would like to delete the values with are double entries, e.g. I have EUR,EUR,EUR,GBP,YEN and I like to remove the double euro entries within removing them from the execel spreadsheet.

Just save then in an array. The new array should look like that: EUR,GBP,YEN

After that I would like to write them to another spreadsheet.

My code so far:

Dim ArrayCurrency As Variant
RangeStart = "E2"
RangeEnd = "E"
RangeNew = RangeStart & ":" & RangeEnd & lRow
CurrencyArray = Range(RangeNew).Value

For Each element In CurrencyArray

Next element

I hope that you can help me!

Best regards Matthias

Answer 1

Use Dictionary object for unique values - in the future.

For your current case, you may use RemoveDuplicates method on the range.