You can build the range dinamically.

look at this thread, thereis a similar problem:
http://groups.google.com/group/micro...39ab413df2e6d#

hth

Carlo

On Dec 27, 10:56*am, "Derek Hart" wrote:
I have seen how you can build a combo box in a cell by going to
Data...Validation...Allow:List and using a named range to define a list.
But this list cannot change with some management by removing the named range
and inserting or removing data from the range, and then naming the range
again. *I wish to make it easy for a user to paste a column of data into the
same range, and then have that take automatically in the combo box list. Any
ideas on clever ways to do this? *Can I build the list dynamically using vba
.AddItem, or some other way?