A1 is a drop down menu with 2 choice. when nothing is selected i want t
be able to choose the cell colours of B1-G1 myself. as i have a macro t
count cells by cell colour. However, when one of these options i
selected i want it to delete all the cell info and colours from B1-G1

--
alex198
-----------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...fo&userid=3749
View this thread: http://www.excelforum.com/showthread.php?threadid=57324