A formula to "clear to zero" multiple cells

[Douglas Strinz]

Hello all,

I have made a calculator that has many cells where number values are added.

I would like to make a master RESET button that will clear all the cells
that I program into the formula

Thanks in advance,

Doug

 

[Don Guillett]

You will have to use a macro something like this.

Sub clearspecifiedcells()
Range("d8,e3").ClearContents
End Sub