A formula to "clear to zero" multiple cells

  • Thread starter Thread starter Douglas Strinz
  • Start date Start date
D

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
 
You will have to use a macro something like this.

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