View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Emmery[_2_] Tom Emmery[_2_] is offline
external usenet poster
 
Posts: 9
Default 2 dimensional array (variant)

How to create a 2-dimensional array, initialize it and read from it ?

Example:
fixed number of rows(3), variable number of values per row (max 6)

I've tried the following code:
dim MyArray as variant
redim MyArray(1 to 3, 1 to 7)

How to assign values to it ?
row 1: (1,"h", 2)
row 2: (4,"i",5,"j",6,"k",1)
row 3: (7,"z",3,"y",3)

Then how to select "j" (row 2, index 4) ?