Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please excuse my previous response.
Maybe I should get enough sleep before responding to questions. If no lower bound is declared in an array then the lower bound is zero... ReDim MyArr(100) is the same as ReDim MyArr(0 to 100) I believe with seven dimensions in the array that you are having memory problems. Arrays eat memory and multi-dimensional arrays are hungry. You need to rethink your approach. In almost all cases, a two-dimensional array should suffice... ReDim (0 to 30, 0 to 202) -- Jim Cone Portland, Oregon USA "BillCPA" <Bill @ UAMS wrote in message Actually, I use the zero level of each element, so I want them to be 0 to nn. Here is the pertinent code: Public arrFile() As String - this is in Module 1 Public FldrNo0 As Integer - this is in Module 1; FldrNo1-6 are the same as 0 The following ReDim statement is in Module 3: ReDim arrFile(FldrNo0, FldrNo1, FldrNo2, FldrNo3, FldrNo4, FldrNo5, (FldrNo6 + 10)) (The array is not a passed parameter, and there is no other ReDim before this.) Currently, when the code gets to the ReDim, these are the values of FldrNon: FldrNo0=30; FldrNo1=19; FldrNo2=51; FldrNo3=70; FldrNo4=83; FldrNo5=168; FldrNo6=202 If I stop the run immediately after the ReDim statement, and check the UBound of any of the elements, it shows 'Subscript out of Range'. If I continue running until I populate the array, it executes the statement (see below) that places a value into the array without giving any error, but if I check the value in the array immediately after that statement, it shows 'Subscript out of Range'. arrFile(FldrNo0, FldrNo1, FldrNo2, FldrNo3, FldrNo4, FldrNo5, FldrNo6) = f0.Name As I mentioned, it does exactly the same with 6 and 5 dimensions, but when I get to 4 dimensions, it works fine. Extremely frustrating. -- Bill @ UAMS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
array dimensioning | Excel Programming | |||
Excel VBA Compile Error when dimensioning jagged array | Excel Programming | |||
dimensioning variables | Excel Programming | |||
dimensioning across modules | Excel Programming | |||
Dimensioning Arrays | Excel Programming |