Hi all,

I have a general request. I am after a combo box, to open on user for
when workbook opens, listing r2,r3,r4,r5....that when an item i
selected, runs through a range named 'colours' on sheet1 and clear
contents in range rows except for the selected ones.

Any ideas??

Cheers!!!!

--
gavme
-----------------------------------------------------------------------
gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666
View this thread: http://www.excelforum.com/showthread.php?threadid=26833