Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to define and use multi-dimensional variables.
I can define variables of type variant (i.e. Dim field() as variant), and then refine them by using: Redim field(1 to i); to build i variables (field(1) , field(2) ... field(i)) in variant field. What I want to do now is define the variables field(1), field(2) etc. to ... field(i), such that each 'field(i)' variable contains ~4 sub-variables. i.e: field - field(1) - (fldRange as Range Name As String Title As String index As Integer, etc. field(2) - fldRange as Range Name As String Title As String index As Integer, etc; to .................. field(i) - fldRange as Range Name As String Title As String index As Integer Is this possible, and can anyone explain how I can do this? -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multi Dimensional Lookup | Excel Discussion (Misc queries) | |||
Multi Dimensional Array | Excel Programming | |||
Multi Dimensional Array | Excel Programming | |||
Multi-dimensional arrays | Excel Programming | |||
Multi-Dimensional Array Let & Get | Excel Programming |