That won't work in Excel2000 and earlier for an x that is a 100x100
array, or any array of more than 5461 elements. And in any event, it
doesn't get at the OP's request for getting a range column into a VBA array.

Alan Beban

Tushar Mehta wrote:
A one way transfer, i.e., from the array to the XL range and if want to
pick the vector that corresponds to the outer index, the following will
work:

Range("A1").Resize(100, 1) = .Transpose(.Index(x, 1))

It transfers the first row of the 2D array x into 100 cells in column A
of the worksheet starting with A1.