Thread: Need VBA code to periodically zero out 10,000 cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lothario[_3_] lothario[_3_] is offline
external usenet poster
  
Posts: 1
Default Need VBA code to periodically zero out 10,000 cells
Hi,

I have 10,000 cells that need to be zero-ed out periodically.

Can you give me some VBA code that I can attach to a "Zero Out"
button?

So every time the "Zero Out" button is pressed the cells in the range
a1:a10000 are will be assigned the value of zero.

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Reply With QuoteReply With Quote