initialize an array to 0

this should be an easy question for the excel gurus out there...i have an array with size 100 and i want to initialize every value in the array to 0...is there an easy way to do this without running a for loop?

try this


Redim a(100) ' initial declaration of the variable

your code


Rem Clear A array

redim a(100)

more code

Best N10


"kdp145" <[email protected]> wrote in
message news:[email protected]...
>
> this should be an easy question for the excel gurus out there...i have
> an array with size 100 and i want to initialize every value in the
> array to 0...is there an easy way to do this without running a for
> loop?
>
>
> --
> kdp145
> ------------------------------------------------------------------------
> kdp145's Profile:
> http://www.excelforum.com/member.php...o&userid=29594
> View this thread: http://www.excelforum.com/showthread...hreadid=521719
>

Use the Erase function. If the array is dynamically resized with
ReDim, you'll have to ReDim it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"kdp145" <[email protected]>
wrote in message
news:[email protected]...
>
> this should be an easy question for the excel gurus out
> there...i have
> an array with size 100 and i want to initialize every value in
> the
> array to 0...is there an easy way to do this without running a
> for
> loop?
>
>
> --
> kdp145
> ------------------------------------------------------------------------
> kdp145's Profile:
> http://www.excelforum.com/member.php...o&userid=29594
> View this thread:
> http://www.excelforum.com/showthread...hreadid=521719
>

kdp145 wrote:
> this should be an easy question for the excel gurus out there...i have
> an array with size 100 and i want to initialize every value in the
> array to 0...is there an easy way to do this without running a for
> loop?
>
>

I don't know what you mean by "i have an array", but any of the
following will result in an array initialized with zeroes:

Dim arr(100) As Integer
Dim arr(100) As Long
Dim arr(100) As Double

Alan Beban