You can use a dynamic range as the source for the combobox, and it will
automatically expand as you add entries to the list. There are
instructions he

http://www.contextures.com/xlNames01.html

bach wrote:
Hi,

I need to copy all information either in a colum or in a range across
to another sheet or a combo box.

Example I have a colum populating a combo box so when data is added to
this will update the combo box. I get a combo box with a lot of blank
enteries, because I have selected the whole colomn.

Is there a way to check how many rows in that coloum have data in them
and update this to the combox???


Bach




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html