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.
Bright01Asked:
Who is Participating?
 
NorieVBA ExpertCommented:
Perhaps.
Range("A1").Value = ""

Open in new window

0
 
Bright01Author Commented:
Quick and consise.  Works perfectly!

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.