Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will reset cells to zero
Does anyone have something I could use for the above?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will reset cells to zero
If the cells in question have formulas, then you would need to alter the
input cells so that the formulas calculated to zero. If you want any cell containing a numeric constant to be zero Sub Resettozero() Activesheet.usedrange.Specialcells(xlConstants,xlN umber).Value = 0 End Sub -- Regards, Tom Ogilvy "Macro Beginner" <Macro wrote in message ... Does anyone have something I could use for the above? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a macro that will reset cells to zero
Hi,
Dim Rg As range set rg=range("A1:A10") 'To assign Zero (0) ... or any other value to whole range: Rg.Value= 0 'To clear the range and make it Empty: 'Rg.ClearContents -- Regards, Sébastien <http://www.ondemandanalysis.com "Macro Beginner" wrote: Does anyone have something I could use for the above? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset Cells Value | Excel Worksheet Functions | |||
reset certain cells to a default value | Excel Worksheet Functions | |||
Reset Macro | Excel Discussion (Misc queries) | |||
reset cells to 0 all at once | New Users to Excel | |||
reset cells | Excel Discussion (Misc queries) |