Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Multi-Dimensional Array
I am getting a sub-script out of range error when trying
to populate my multi-dimensional array. Below is the code for declaring the array as well as the code to populate the code: ReDim Preserve AppNames(0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1)) .. .. .. AppNames(j, 0) = cmbAppList.Text AppNames(j, 1) = cmbWPA.Text AppNames(j, 2) = AppLoc & "\" & cmbWPA.Text & "\" & cmbAppList.Text If I have just 2 values, this works fine, but I need it to capture 3 values. Any ideas as to why this is not working? Any help would be appreciated. Thanks. Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Multi-Dimensional Array
Sorry
but you can only redim the last dimension, the other will remain the same, That information come in the Help The last dimension is the one of the right, so if you have three dimensions, like AppNames(aDim,bDim,cDim) you can change only the cDim value and must retain fixed the other values, so you need to change your code Francisco Mariscal fcomariscal at hotmail dot com -----Original Message----- I am getting a sub-script out of range error when trying to populate my multi-dimensional array. Below is the code for declaring the array as well as the code to populate the code: ReDim Preserve AppNames(0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1)) .. .. .. AppNames(j, 0) = cmbAppList.Text AppNames(j, 1) = cmbWPA.Text AppNames(j, 2) = AppLoc & "\" & cmbWPA.Text & "\" & cmbAppList.Text If I have just 2 values, this works fine, but I need it to capture 3 values. Any ideas as to why this is not working? Any help would be appreciated. Thanks. Kirk . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Multi-Dimensional Array
You dimensioned the array with 3 subscripts.
ReDim Preserve AppNames(0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1)) Your assignment statements use only 2 subscripts. On Tue, 26 Aug 2003 07:05:44 -0700, "Kirk" wrote: I am getting a sub-script out of range error when trying to populate my multi-dimensional array. Below is the code for declaring the array as well as the code to populate the code: ReDim Preserve AppNames(0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1), 0 To (ArrayCnter - 1)) . . . AppNames(j, 0) = cmbAppList.Text AppNames(j, 1) = cmbWPA.Text AppNames(j, 2) = AppLoc & "\" & cmbWPA.Text & "\" & cmbAppList.Text If I have just 2 values, this works fine, but I need it to capture 3 values. Any ideas as to why this is not working? Any help would be appreciated. Thanks. Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Dimensional Lookup | Excel Discussion (Misc queries) | |||
newbie question on multi-dimensional array | New Users to Excel | |||
How to declare Multi-dimensional dynamic array? | Excel Programming | |||
Declaring Dynamic Multi-dimensional Array | Excel Programming | |||
sort multi-dimensional array on numeric data? | Excel Programming |