One way:

Dim vArr As Variant

vArr = Range("A1:J10").Value

which loads the values in the range into a (1 To 10, 1 to 10) variant
array.



In article
,
brittonsm wrote:

How do I take a selection of cells on the sheet and load them into an
Array in VBA?

-Steve