Hi David

Read this example for a listbox
http://www.j-walk.com/ss/excel/tips/tip47.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"David" wrote in message k...
Hi

I am running a macro that looks at column "a" and populates the cells value
in a combo box using additem.

My problem is that if there are duplicates or blank cells i dont want them
populated in the combo box.

Pleae help

Thanx