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