Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fastest way to reset to zero an array
Hello
This is a relatively simple question but I can't find it on google group. What is the fastest way to reset an array to zero (or the value by default). (in this case, performance is key, every micro-second counts!) Intuitively, I would say that going through every single cell and setting it to zero must be under-efficient, as VBA has to interpret a let more instructions that if there is a function that already does that. I was thinking to "redim". But zero-ing an array is not redim's main purpose. Is there a better way? Thanks Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the fastest way to copy a range to a 2D array? | Excel Programming | |||
Fastest way to find item in an array. | Excel Programming | |||
fastest sorting routine for 2-D array of long values | Excel Programming | |||
Can I reset an array to myarray() | Excel Programming | |||
Can I reset an array to myarray() | Excel Programming |