Load data to two-dimensional array

Hallo.

How do I load data into a two-dimensional array?

I'm going to have a (1,1) array, in which I should be able to load a X and Y respectively. (Rows , Columns). Any ideas - it's important it's the variable X and Y there is loaded into the array.

Thanks

Sorry, it's a (1,2) array - one row and two columns.

The dimension of the array will be (1,2) in which I would like to load data (X,Y). The X and Y will represent the cell reference, e.g. B2 will be (2,2).

I'll use activecell.row and activecell.column to get the values X and Y.

Originally Posted by mike7952

Try this

Please Login or Register  to view this content.

Thank you - it seems to work.