Bright01
asked on
Clearing data from a cell.......
EE Pros;
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.
.ClearContents
.Clear
.ClearFormats
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,
B.
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.
.ClearContents
.Clear
.ClearFormats
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,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
B.