Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conceptual Question about ReDim
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
newbie redim question | Excel Programming | |||
need some conceptual guidance, advanced excel | Excel Programming | |||
new guy with a conceptual question | Excel Programming | |||
ReDim an Array | Excel Programming | |||
Conceptual Problem with DAO/ADO Recordset | Excel Programming |