Thread: reset a range of cells to zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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
Reply With QuoteReply With Quote