Hi

You can use Advanced filter to create a list without duplicates
and delete the blanks in that list with a macro.
You can use that range then in the combobox

See
http://www.contextures.com/xladvfilter01.html#FilterUR


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



"andrewbears" wrote in message
...
I have a combobox on a sheet that a user makes a selection from to filter a
column on another sheet. The combobox displays the values from an entire
column on yet a third sheet - a master list of values. I want the
combobox
to act like an Autofilter drop down i.e. display no blanks and no
duplicates.
Any ideas?
Thanks.