Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA code to periodically zero out 10,000 cells
Hi:
Sub ZeroOut Range("A1:A10000").Value = 0 End Sub Regards, Vasant. "lothario" wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA code to periodically zero out 10,000 cells
Sub ZeroOut()
Range("A1:A10000").Value = 0 End Sub or if you want to make them blank Sub ClearOut() Range("A1:A10000").Clearcontents End Sub -- Regards, Tom Ogilvy lothario wrote in message ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA code to periodically zero out 10,000 cells
Range("a1").resize(10000).value = 0
or range("a1:a10000").value = 0 lothario wrote: 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/ -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA code to periodically zero out 10,000 cells
Thank you very much.
------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not calculating periodically | Excel Discussion (Misc queries) | |||
How do I have Excel automatically save a file periodically? | Excel Discussion (Misc queries) | |||
formula to update dates periodically | New Users to Excel | |||
Periodically listing files in a folder | Excel Discussion (Misc queries) | |||
Periodically exporting Excel sheet to HTML | New Users to Excel |