chris2727272727
Board Regular
- Joined
- Jul 10, 2005
- Messages
- 152
what the best way to assign the value of cell A1: a50 to a 50 variant array ie a3 = myarray(3) etc etc
myarray = Application.WorksheetFunction.Transpose(Range("A1:A50"))
Sub foo()
Dim tmpArr() As Variant
Let tmpArr = Range("a1:a50").Value
MsgBox tmpArr(3, 1)
End Sub