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


--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=401881