reset a range of cells to zero

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

I want a macro in Excel to reset a range of cells to zero, can anyone help me
please
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to hide rows with zero in specifc column range 2
Displaying zeros in cells 2
Macro and a range of cells 6
How to calculate the number of non-zero cells in range? 6
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Question about conditional formatting of zeros in Excel 0
Enter value zero into all cells in multiple ranges? 4
MIN ingnoring zero sum in an range of cells 2

Back
Top