| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Cell = "XXX" Then clear all other cells formula | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Formula for Multiple "IF's" or maybe "COUNTIF's"??? | Excel Discussion (Misc queries) | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Linear Mode
