View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Charles Charles is offline
external usenet poster
 
Posts: 62
Default Fastest way to reset to zero an array

No mostly arrays of double.

Also I did a surprising test. It looks like doing
for i = 1 to 10000
x=x+1
next i
for i = 1 to 10000
x=x+1
next i

is taking 10% longer than
for i = 1 to 10000
x=x+1
x=x+1
next i

which seems to back my suspicion that giving more code to interpret is
taking longer even if at the end of the day the code did the same
number of operations.