Did you paste j-walk's code in a standard module?
How did you call it ?
Please post your code.

Cheers,
--
AP

a écrit dans le message de news:
...
I just found this site where it says that the vba code will get you a
unique list. But it is not working. Do I have to do anything special
to this code? I cut and pasted it into vba editor and then called the
funcion on the spreadsheet. I am getting a #NAME? error. What is
causing this?

here is the site....
http://j-walk.com/ss/excel/tips/tip15.htm

I was planning on sending this list to the listbox

Jeff