I'm trying to get all of the unique elements from an array using vba in excel. Here's the pseudo code for what I'm trying to do in vba.

array '<-- Array with redundant elements
uniqueArray '<-- Array with unique elements

for each element of array
if element not in uniqueArray
uniqueArray.append(element)
else
do nothing