Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a limit on how many dimensions an array can have? VB Help seems to
indicate it is only limited by memory (I have a 4GB machine), and even then actually has no limit because data is written to and read from disc as needed. I cannot get an array of larger than four dimensions to work (I want seven). I have it defined as dynamic. The code will initially ReDim the array without showing any error. It will allow me to assign values to it. But if I am monitoring the code and look at the array after a value has been assigned, it indicates 'subscript out of range', even though the index values for each dimension are well within the values at the time of the ReDim. I reduced the number of dimensions down by one from 7, and when I got to four, it worked. Any thoughts? -- Bill @ UAMS |
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 |