Question

excel vba 把range("A1:B3")如何直接转化成vba下的二维数组?

dim a
a=range("A1:B3")
b=ubound(a) 'b=3 ???
我想得到的是一个vba下的3*2二维数组

Answer 1

a就是二维数组啊

Answer 2

Dim a
a = Application.Transpose(Sheet1.Range("a1:b3"))
MsgBox UBound(a)

Answer 3

b=a b=ab=ab=ab=ab=ab=ab=a