Combo Box shink and grow
 

I have searched for a while now for what I thought was a simple
solution to a newbie problem.
I have a combo box populated by a column that I reference as a named
list. The column has 12 items in it but I made the reference for 50
cells to cover new data inputed. I just want my drop down list to be
clean and not have 38 blank spaces in it or if an item is removed in
the middle you see a blank space.
How do I get the drop down box to shrink and grow as the data shrinks
and grows?

Combo Box shink and grow
 

Hi

Use an dynamic range to fill the Combobox
http://www.contextures.com/xlNames01.html#Dynamic

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


"jeffagin" wrote in message oups.com...
I have searched for a while now for what I thought was a simple
solution to a newbie problem.
I have a combo box populated by a column that I reference as a named
list. The column has 12 items in it but I made the reference for 50
cells to cover new data inputed. I just want my drop down list to be
clean and not have 38 blank spaces in it or if an item is removed in
the middle you see a blank space.
How do I get the drop down box to shrink and grow as the data shrinks
and grows?