2d array – Useful code

VBA – Ubound of Multidimensional Array or How to Get What We Need?

Posted on April 12, 2021 by

Transforming Range to Array in VBA is actually a one liner – we take the range and we assign it to a variant:

    Dim myRange As Range
    Set myRange = Range("a1").CurrentRegion
    
    Dim myArray As Variant
    myArray = myRange

Dim myRange As Range

Set myRange = Range("a1").CurrentRegion

Dim myArray As Variant

myArray = myRange

The “strange” part is that the array is converted to 2-dimensional array after this: and working…