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

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

On Fri, 29 Oct 2004 14:27:01 -0700, Stratuser
wrote:

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

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

Alan Beban

Myrna Larson wrote:

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

On Fri, 29 Oct 2004 14:27:01 -0700, Stratuser
wrote:


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

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.

On Fri, 29 Oct 2004 16:27:40 -0700, Alan Beban wrote:

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

Alan Beban

Myrna Larson wrote:

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

On Fri, 29 Oct 2004 14:27:01 -0700, Stratuser
wrote:


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