I have set up an array that holds string values from excel, (option
base 1).

Is there a function that will delete all the duplicate values in the
array and just leave the unique ones, i have many such string array
that i need to do the same thing for.

My code is like this

term() as string (declare array)

Redim term(noItems) (re dim array with the number of items)

Import data to the term array

Call Unique(term) (pass the term array to the unique function and get
back the term array with just the unique items only)

Can any body help

Cheers

Tony