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