ExcelBanter - reset a range of cells to zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - reset a range of cells to zero (https://www.excelbanter.com/excel-discussion-misc-queries/238906-reset-range-cells-zero.html)

Jen

reset a range of cells to zero

I want a macro in Excel to reset a range of cells to zero, can anyone help me
please

Jim Thomlinson

reset a range of cells to zero

Here are 2 ways depending on if you want to reset the active sheet or a
specific sheet...

Public Sub ResetZero()
ActiveSheet.Range("A1:A10").Value = 0
Sheets("Sheet3").Range("A1:A10").Value = 0
End Sub
--
HTH...

Jim Thomlinson

"Jen" wrote:

I want a macro in Excel to reset a range of cells to zero, can anyone help me
please

All times are GMT +1. The time now is 05:44 PM.