PDA

View Full Version : Clear cell without deleting formula?



M0ng00se
03-13-2008, 10:28 AM
How can i clear the contents of a cell without deleting the formula inside it?

Selection.ClearContents deletes everything including formula.... :think:

Bob Phillips
03-13-2008, 10:36 AM
The contents of the cell is the formula, do if you clear it the formula goes, if you don't, it shows the result of that formula.

lucas
03-13-2008, 10:38 AM
If you want to reset it you will have to work on the cells that the formula reflects......not the cell with the formula.

lucas
03-13-2008, 10:39 AM
sorry Bob......not quick enough...