A formula to "clear to zero" multiple cells
 

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

A formula to "clear to zero" multiple cells
 

You will have to use a macro something like this.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Douglas Strinz" <Douglas wrote in message
...
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