Hi!

I'm using this Visual Basic code to copy a column of names into
another column. This other column will only contain the unique names
from the original column of names.

Worksheets("NAMES").Range("A2:A500").AdvancedFilte r
Action:=xlFilterCopy, CopyToRange:=Worksheets("NAMES").Range("C2"),
Unique:=True

For whatever reason, it doesn't work a certain list of names I'm
testing, and I'm stuck trying to figure out how to get it to work (or
create another formula to extract the unique names). Doesn't even work
correctly if I paste the names below into a new spreadsheet and only
the function above!

Microsoft's VBA help seems pretty clear cut on this - simply have
Unique=True:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

Alcantara-Hernandez
Alkire
Alcantara-Hernandez
Alkire
Alcantara-Hernandez
Alcantara-Hernandez
Anderson
Bauer
Alcantara-Hernandez
Alcantara-Hernandez
Alcantara-Hernandez
Alkire
Alkire
Baker
Zolfagari
Alcantara-Hernandez
Alcantara-Hernandez
Alkire
Anderson
Asrani

I've put a copy of the spreadsheet he
http://www.mytempdir.com/1244482

Thanks for any help!
=)