You could loop but the quickest method is to use a variant variable:

Dim myArray As Variant
Set myArray = Selection

Then, for example (if you've used columns A and B), myArray(1,1) will be
A1's value, myArray(1,2) B1's, myArray(2,1) A2's, etc.

"willz99ta via OfficeKB.com" wrote:

Howdy,

I'm trying to find the right syntax to fill a two dimensional with the first
two columns in my excel spreadsheet. The two columns could have as few as 1
or as many as 60,000 records in them.

Thanks,
Will

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1