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