How can i clear the contents of a cell without deleting the formula inside it?
Selection.ClearContents deletes everything including formula....
How can i clear the contents of a cell without deleting the formula inside it?
Selection.ClearContents deletes everything including formula....
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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
If you want to reset it you will have to work on the cells that the formula reflects......not the cell with the formula.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
sorry Bob......not quick enough...
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln