You generally use ReDim when you don't know when you write the
code how many elements are needed in the array, i.e., the number
of elements is computed when the code runs, and will vary from
one run to another.


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




"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!