Hi!

I have a range on a worksheet called "ethyl" that is A1:AM2521 which is a data set. I'd like to send this range to a VBA variable say "earray" of the same size and then use the array to reorganize/restructure the data into a more convenient form for analysis. Can I do something like:

Option Base 1

Sub ethylene()
Dim earray(1 To 2521, 1 To 39) As Variant
Dim x As Integer, y As Integer, i As Integer, j As Integer

'range ethyl is already named
earray = range("ethyl")

'....

End Sub

Thanks in advance for your help!

Erik_G