Re: Manually Filling A 2-d Array

Sehr Geehrte Andy,

First off, I will say that your post is a little bit hard to read, so please forgive me if I am oversimplifying

First of all, a 2 dimension array is really just a grid (or a matrix), where the items in the brackets are the co-ordinates of the values within that grid.

You have initialised your array with 2 dimensions

- so within your grid there are 5 rows and 4 columns.

When you fill the array, you need to observe this row/column format.

One of the things that is going wrong is that you are trying to fill your 2 dimensional array with 5 dimensions, (and within each of the 5 dimensions there is another array with 4 dimensions!).

```
Array(
Array("B1", 2, strCellNameRng, strSig), _
Array("D1", 1, .Range(strOrgaInfoRng).Cells(2).Address, strSig), _
Array("E1", 1, strCellRunNRng, strSig), _
Array("I1", 2, strTypeRng, strSig), _
Array("G1", 2, .Range(strOrgaInfoRng).Cells(3).Address, strSig)
)
```

Another problem with your code is the unqualified reference

`.Range(strOrgaInfoRng).Cells(2).Address`

Here the code witll not compile because there is no indication of what object the

`.Range(strOrgaInfoRng).Cells(2).Address`

belongs within

Perhaps you could tell us a little bit more about what you are trying to do?

G