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?
Bookmarks