To do what you want, you would need to use complex formulas to build you
list of unique, alphabatized names and then probably a defined name to pick
up that new list.

I assume you can figure out how to do that.

--
Regards,
Tom Ogilvy

"Keith" wrote in message
om...
Hi,

I have a drop-down box I'd like to fill with unique, alphabetized
names sourced from another sheet. However, the list of names on the
other sheet contains duplicate name entries and varies in length as
the list is updated.

Currently I reference the entire column that contains the names, which
results in duplicate entries, and many many spaces.

Is there a way to dynamically reference this list so that the
drop-down doesn't have any duplicates or spaces? Preferably I'd like
to do this in the ListFillRange property of the combobox, and without
any VB code.

Thanks,

Keith