I have a macro up and running that counts the colour of cells. I have
added a drop down menu which when one of the options is selected it
turns the whole row grey. However, my macro still counts the colours
that were orginalling in the drop down menu before anything was
selected. Is there a macro that will clear a row of cells when
something from the drop down menu is selected?


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=573032