View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arthur Negus via OfficeKB.com Arthur Negus via OfficeKB.com is offline
external usenet poster
 
Posts: 1
Default Definition and use of multi-dimensional variables

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