Sub a() Dim tmp() As Variant Dim arr1, arr2 tmp = Range("A1:D8") '取一行成一维,以第三行为例 arr1 = Application.Index(tmp, 3, 0) '取一列成一维,以第四列为例 arr2 = Application.Index(Application.Transpose(tmp), 4, 0) End Sub
Sub a() Dim tmp() As Variant Dim arr1, arr2 tmp = Range("A1:D8") '取一行成一维,以第三行为例 arr1 = Application.Index(tmp, 3, 0) '取一列成一维,以第四列为例 arr2 = Application.Index(Application.Transpose(tmp), 4, 0) End Sub