Eliminating Duplicates in an Array (assumes prior sort):   Return to List

OldSelection = ExtractionArray(1)' This assumes option Base 1
For i = 2 To UBound(ExtractionArray())
    If ExtractionArray(i) = OldSelection Then
        ExtractionArray(i) = ""
        GoTo LOOP_NEXT
    Else
        OldSelection = ExtractionArray(i)
        GoTo LOOP_NEXT
    End If
LOOP_NEXT:
Next
For i = 1 To UBound(ExtractionArray())
    If Len(ExtractionArray(i)) > 0 Then
        Selection.InsertAfter Text:=ExtractionArray(i) & Chr(13)
        Selection.START = Selection.End
    End If
Next

See also:
Array Converted to Delimited Text String
Building an Array of Filenames (after browse)
Delimited Text to an Array (similar to Split())
Determining Upper & Lower Array Bounds
Erasing an Array (removing all the elements)
Feed an Array into a New Document (del dupes)
Filename Array from Active Directory
QuickSort routine
QuickSort Single Dimension
QuickSort (Fast!!) (Multidimensional on 2 dims)
QuickSort (Fast!!) (Multidimensional on 3 dims)
SQL Query Results placed in an Array
Using Split() function to create Array



Note to Webmaster