View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Fastest way to reset to zero an array

You can use Redim

If you are dealing with large string arrays you may find it faster to Loop

Regards,
Peter T

"Charles" wrote in message
oups.com...
Ooops. Just saw that erase won't do the trick. Most of my arrays are
dynamic and in that case erase will not only reset the elements of the
array but free up the memory.

I guess I should go for the loop then.