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