|
Sub aa()
Dim arr, x, aa, bb, xx, cc, d, s
arr3 = Range("x5").CurrentRegion.Value
'x5 的区域都是非空数值
ReDim re(1 To UBound(arr3) * 8, 1 To 1)
MsgBox re(6, 1)
For i = 1 To UBound(arr3)
For ii = 1 To 8
Cells(i, ii) = re(i, 1)
Next
Next
End Sub
- Sub aa()
- Dim arr, x, aa, bb, xx, cc, d, s
- Dim re() '下面需要重新定义数组,所以开始要先定义re为一个数组
- arr3 = Range("x5").CurrentRegion.Value
- 'x5 的区域都是非空数值
- ReDim re(1 To UBound(arr3) * 8, 1 To 1) '因为重新定义了数组,所以数组是空的
- '如果重新定义前,数组赋值过,REDIM 后也会把数组清空的
- '如果数组赋值过,REDIM 时还要保留源数据,需要加上 Preserve关键字
- '写法 ReDim Preserve re(1 To UBound(arr3) * 8, 1 To 1)
- '新数组re赋值,可以使用循环的方法进行赋值
-
- MsgBox re(6, 1)
- For i = 1 To UBound(arr3)
- For ii = 1 To 8
- Cells(i, ii) = re(i, 1)
- Next
- Next
- End Sub
复制代码
|
|