I have a table that has a column of states. I have formula that will give me
a list of all the unique values in that column:

=INDEX($A$2:$A$2208,MATCH(0,COUNTIF($B$2:B2,$A$2:$ A$2208),0))

I'd like to do the same with some vba code to create a new worksheet with
the values that it creates. Any suggestions?

Niq