VBA里应该怎么定义一个动态的二维数组 – java – 前端

VBA中动态定义一个二维数组，案例代码如下：//定义动态数组ttSub tt()Dim a() As IntegerReDim a(1 To 2, 1 To 1) As Integera(1, 1) = 10i = 10ReDim Preserve a(1 To 2, 1 To i) As IntegerMsgBox a(1, 1)End Sub