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