Option Base 0 Sub test() Dim ArrData As Variant Dim Arr As Variant ArrData = Array(1, 2, 3) Arr = ArrData Stop End Sub
如上,ArrData这个时候下标最小为0,这样赋值给Arr的时候,Arr下标也会为0,我应该怎么定义这个Arr,在不用循环的情况下,进行怎样的处理,可以使Arr最小下标为1,且结果为: Arr(1)=1,Arr(2)=2,Arr(3)=3
Option Base 0 Sub test() Dim ArrData As Variant Dim Arr As Variant ArrData = Array(1, 2, 3) Arr = ArrData ReDim Preserve Arr(1 To UBound(Arr) + 1) Stop End Sub
|