Clearing data from a cell.......
Posted on 2013-01-17
Fairly easy question. I've got a set of cells that have a validation list and conditional formatting based on the selection for data in the cell. I also have an "erase" macro in order to reset the cells back to where they are clear.
I've used these three statements but they either erase the validation, the conditional formatting or both. If I use ClearContents, I get the contents cleared but the Conditional Formatting does not reset.
Is there a statement I should be using?
Thank you in advance,