Hi,

I need to work on a multi-dimensional string-type array in VBA.  Let
me call it object_list and assume that it has 3 dimensions for the
time being.

Therefore, I'll declare it as

Dim object_list(n, n, n) as string
where n is the length of one of the dimensions.

Now, the tricky thing is that elements of object_list need to be
updated frequently, either about the number of elements in a dimension
or content of the elements themselves.  To facilitate this kind of
updating, I plan to place and do all the editing of the 3 rows of
elements in an Excel worksheet first and then load the 3 rows of
elements into array object_list.  The elements are supposed to be put
into columns A, B and C in an Excel worksheet.  For each action of
this kind, the number of elements for each dimension, that is n, may
vary.  So, may I ask how to achieve the above by writing a VBA macro
to load the 3 rows of elements from an Excel worksheet into array
object_list whose length may change on each occasion?   Thanks.

Mike