3d array

I am attempting to read (designated/marked pairs of string values) from a number of (tables on one sheet) into an array.

The number of tables on the sheet changes over time.

The number of rows in each table changes over time.

The number of columns in each table is fixed at two, and when the first of the two columns is marked the items in that row constitute the pair of values.

The marker for the information from the cells that I want read into the array from each table is that the first cell in each needed row will have a comment created/attached to it.

Everything in the following blows up (fails) at the point: arReport(intTblCtr) = tbl.name

tbl.Name is correct, but obviously my handling of assigning values to an array isn't.

I have more explanation of what I intend to do in the comments of the following code.

I am probably mis-using the word "parameter" in my attempt to describe the three "positions" (labeled immediately hereafter: "A", "B" and "C": array(A,B,C) ) within the entire array.

Please Login or Register  to view this content.

Help?!?

I did my best to break everything down for I know sometimes I post requests with presumed knowledge of what I am trying to do swimming around in my head!

Thank-you!

A sample spreadsheet so we can see the data in the spreadsheet will likely be very helpful in visualizing what you are wanting to go into what element of the array.

Note that this syntax:

Please Login or Register  to view this content.

is invalid. arReport is a 3D array, so any assignment statement must reference a single element using all three indices. It is not clear to me exactly where in the array you want to store these pieces of information, but your assignment statement must refer to a single element:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

When you index a 3D array, you need three indices.

The second dimension of the array will only be as large as the number of rows in the last table.

Ah, missed that.

So, does it all work?