Sub 增加数组维数()
'我想把原数组(2行4列)扩充到3行4列,前三行要保留原来的数据
Dim Myarr
Myarr = Range("a1:d2")
Myarr = Application.WorksheetFunction.Transpose(Myarr)
ReDim Preserve Myarr(0 To 3, 0 To 2) '为什么不行?应该如何?
'下标用错了,应该
ReDim Preserve Myarr(1 To 4, 1 To 3)
复制代码
Myarr = Application.WorksheetFunction.Transpose(Myarr)
End Sub
Sub 增加数组维数()
Dim Myarr
Myarr = Range("a1:d2")
Myarr = Application.WorksheetFunction.Transpose(Myarr)
ReDim Preserve Myarr(1 To 4, 1 To 3)
Myarr = Application.WorksheetFunction.Transpose(Myarr)
End Sub
Sub 增加数组维数()
Dim Myarr
Myarr = Range("a1:d2")
Myarr = Application.WorksheetFunction.Transpose(Myarr)
ReDim Preserve Myarr(1 To 4, 1 To 3)
Myarr = Application.WorksheetFunction.Transpose(Myarr)
End Sub