Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi, ive read through previous threads and im struggling to understand
dynamic arrays., specifically resizing. Basically Im using a dynamic array 2 cols wide with variable rows. Im using ReDim Preserve CapturePowers(1 To x, 1 To 2) CapturePowers(x, 1) = name CapturePowers(x, 2) = 0 Ive read you can only redim the last array which is were im lost. Im assuming in my array that 1 to x is the rows, and 1 to 2 is the cols. I can use redim with single arrays fine. I can work out the size Of the array before using it and wondering if this is the best option or the only option. Hope this makes sense regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA syntax help: ReDim Preserve an array | Excel Discussion (Misc queries) | |||
Code for optimization, ReDim Preserve not handling it well, HELP please! | Excel Programming | |||
Redim Preserve doesn't work | Excel Programming | |||
ReDim, Preserve and Multidimensional arrays | Excel Programming | |||
ReDim Problem | Excel Programming |