Sub t9()
arr = Array(1, 35, "a", 4, 13, "b")
arr1 = Application.Transpose(arr)
MsgBox arr1(2, 1) ‘轉(zhuǎn)換后的數(shù)組是1列多行的二維數(shù)組
End Sub
2、二維數(shù)組轉(zhuǎn)一維。
Sub t2()
arr2 = Range("A1:B4")
arr3 = Application.transpose(Application.Index(arr2, , 2)) '取得arr2第2列數(shù)據(jù)并轉(zhuǎn)置成1維數(shù)組
MsgBox arr3(2,)
End Sub
注:在轉(zhuǎn)置時(shí)只有1列N行的數(shù)組才能直接轉(zhuǎn)置成一維數(shù)組
聯(lián)系客服