Log in

View Full Version : Solved: Clear cell contents without deleting formula


austenr
07-20-2010, 05:20 PM
Is there a way to use worksheet change to clear the contents of a cell with a formula in it without deleting the formula as well? If I use

Range("A1").ClearContents

It clears the formula as well.
p45cal
07-20-2010, 06:07 PM
No
mdmackillop
07-20-2010, 11:55 PM
Depends what you mean by "clear"
Range("A1").NumberFormat = ";;;"
YasserKhalil
07-21-2010, 01:11 AM
What purpose of this procedure??!!
YasserKhalil
07-21-2010, 01:22 AM
Formulas are contents of a cell, so what you mean is to perhaps re-set all formulas to 0/""? Not sure how to do that, or even if it is possible.