View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Set an array to zero

Dim NumArray(10) As Integer ' Integer array.
Erase NumArray ' Each element set to 0.

If this post helps click Yes
---------------
Jacob Skaria


"T.Mad" wrote:

Hi all,
How can I set an array to zero without looping to every element? For example
in FORTRAN with a single assignment e.g. Array=0 you can do that. Is there a
similar way in vba?
Many thanks