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