Set an array to zero
 

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

Set an array to zero
 

Two ways and best to see the details in the help file:
Redim
Erase

RBS


"T.Mad" wrote in message
...
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

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