Array type

[tiredofit]

This is my data:

1    4
2    5
3    6

What is wrong with this?

Dim MyArray() As Long
    
MyArray() = Cells(1, 1).CurrentRegion.Value

Seems to only work if MyArray is declared as a Variant.
Thanks

 

[JoeMo]

Will also work if you dimension MyArray like this:

Redim MyArray(1 to 3, 1 to 2)
MyArray() = Cells(1,1).CurrentRegion.Value

 

[tiredofit]

But you haven't declared the array to be of a specific type, hence have implicitly declared it as a Variant.

All my data are integers, so I thought declaring it MyArray as Long would work but it doesn't.

 

[RoryA]

Value returns a Variant, and you can only assign one array to a dynamic array if the types match, hence you can't use Long unless you loop.

 

[tiredofit]

Thanks