[求助]声明数组

28795277

VBA中好像不能声明这样的数组变量！

dim v as integer

dim arr() as integer

...

Redim arr(0 to v) as integer

...

也就是说VBA在数组中不支持用变量来代替数组的下限，如果是这样的话该怎么办？

Trynew

可以的，但变量V必须在Redim语句前赋值，否则相当于：ReDim arr(0 To 0) As Integer

Public Sub xxx()

Dim v As IntegerDim arr() As Integerv = 5

ReDim arr(0 To v) As Integer

arr(1) = 3

arr(3) = 5

Debug.Print arr(1) & arr(2) & arr(3)

End Sub

28795277

可能是我哪里出了问题，我再看看！再次感谢TryNew!