Redim is primarily used with dynamic arrays


Dim myArray() as Double

redim myArray(i to j)

.. . .

if j < k then
redim preserve myArray(i to j + 100)
End if

--
Regards,
Tom Ogilvy


"Nicole B" wrote in message
...
I was wondering: in what situation is it useful to use ReDim? The VBA
help
does not explain the concept much. Does it speed up your program? Can
someone give me some basic explanations and/or examples of when it's
beneficial or necessary?

Thanks!