VBA – Ubound of Multidimensional Array or How to Get What We Need?
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 The “strange” …
VBA – Ubound of Multidimensional Array or How to Get What We Need? Read more »