Excel 学习VBA数组,怎么通过数组传递
Excel 学习VBA数组,怎么通过数组传递
日期:2016-12-25 11:47:31 人气:1
数组作为入参的例子如下:
按地址传递byref
Sub AAATest()
Dim StaticArray(1 To 3) As Long
Dim N As Long
StaticArray(1) = 1
StaticArray(2) = 2
StaticArray(3) = 3
PopulatePassedArray Arr:=StaticArray
For N = LBound(StaticArray) To UBound(StaticArray)
Debug.P