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
Bookmarks