Reset the values to ZERO?

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

How could I reset the values of the used cells on a worksheet back to a starting number like zero
using VBA and not clear the formulas?

Julie
 
Hi Julie
try the following (changes all values to zero)
Sub change_values()
Dim rng As Range

Set rng = Selection.SpecialCells(xlCellTypeConstants, 1)
rng.Value = 0
End Sub
 
RE: not clear the formulas?

The only way would be to either add another condition to the formulas,
so that zero is returned, and/or change the referenced cells so that
zero is returned.

It's possible to make the cells **appear** as zero with a custom format
and NOT loose the formulas, but not "reset their values to zero", unless
using the method stated above.

I have to ask, why do you wish to do this? Perhaps there is a better
way.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top