I want a macro in Excel to reset a range of cells to zero, can anyone help me please
J Jen Aug 4, 2009 #1 I want a macro in Excel to reset a range of cells to zero, can anyone help me please
J Jim Thomlinson Aug 4, 2009 #2 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
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
