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?


--
kdp145
------------------------------------------------------------------------
kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594
View this thread: http://www.excelforum.com/showthread...hreadid=521719

initialize an array to 0
 

try this


Redim a(100) ' initial declaration of the variable

your code


Rem Clear A array

redim a(100)

more code

Best N10


"kdp145" wrote in
message ...

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

initialize an array to 0
 

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

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

initialize an array to 0
 

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