Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: AdvancedFilter - Unique Copy of column of names doesn't work?!
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! =) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding unique names--then converting those names to unique number | Excel Discussion (Misc queries) | |||
Advancedfilter doesn't work when Excel opens, but does when run macro | Excel Programming | |||
Selection to Array then unique with different fields/columns like advancedfilter | Excel Programming | |||
Selection to Array then unique with different fields/columns like advancedfilter | Excel Programming | |||
Stutter in AdvancedFilter Unique Results? | Excel Programming |