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

Option Explicit
Sub abc()
 Dim aArr(1 To 1, 1 To 2)
 Dim i As Long
 aArr(1, 1) = "Hello"
 aArr(1, 2) = "World"
 
 For i = 1 To UBound(aArr, 2)
    MsgBox aArr(1, i)
 Next
 
End Sub

Thank you - it seems to work.