Pass the variant to Unique function.
Function Unique(vSourceArray As Variant)
Dim iFound As Integer
Dim sTargetArray() As Variant
Redim sTargetArray(0) As Variant
sTargetArray(0) = ""
Forall sText In vSourceArray
iFound = False
Forall sNewText In sTargetArray
If sText = sNewText Then
iFound = True
Exit Forall
End If
End Forall
If Not iFound Then
If sTargetArray(0) ="" Then ' First time
sTargetArray(0) = sText
Else
Redim Preserve sTargetArray(Ubound(sTargetArray)+1)
sTargetArray(Ubound(sTargetArray)) = sText
End If
End If
End Forall
Unique = sTargetArray
End Function
No comments:
Post a Comment