Range object to Array object conversion
Either one works, at least in xl2000 and later.
Alan Beban
Myrna Larson wrote:
It won't work if you wrote
Dim MyArray1() As Variant
But it WILL work if you write
Dim MyArray1 As Variant 'no parentheses
On Thu, 31 Jul 2003 16:00:36 -0700, "Yogesh" wrote:
HI ,
The following code works fine :
'eg. of array being assigned to a range object
.Range("A1:A2").Value = MyArray
'just wanted to know whether the reverse is possible
' i.e. something like ---
' MyArray1 = .Range("A1:A3") 'This not working with VBA
Thanks,
Yogesh
|