Assigning Range to Array

[Guest]

I often assign ranges to two-dimensional arrays. I've noticed that I can do
it by declaring the variable as a variant variable, or as an array of
variants. It seems to work either way. Which of these two is better?

Dim MyArray as Variant
MyArray = Range("MyRange").Value

or

Dim MyArray() As Variant
MyArray = Range("MyRange").Value

 

[Myrna Larson]

I always do it the first way, but as you say, it doesn't seem to matter.

 

[Alan Beban]

I'm not certain, but I think the second fails in versions prior to xl2000.

Alan Beban

 

[Myrna Larson]

I think you may be correct. I was thinking, too, that to assign data to
elements of a "normal" array you had to do it cell by cell, with a loop.

 

[Alan Beban]

I think you may be correct. I was thinking, too, that to assign data to
elements of a "normal" array you had to do it cell by cell, with a loop.

No, not if it's declared as a dynamic array.

Alan Beban