|
发表于 2013-7-3 05:55
|
显示全部楼层
本楼为最佳答案
本帖最后由 ligh1298 于 2013-7-3 06:03 编辑
'请再测试- Sub 数组相除()
- Dim arr1(), arr2(), arr3()
- Dim i As Byte
- arr1 = Array(5, 2, 6)
- arr2 = Array(1, 1, 2)
- ReDim Preserve arr3(0 To 2)
- For i = 0 To UBound(arr1)
- arr3(i) = arr1(i) / arr2(i)
- Next
- Cells(1, 1).Resize(3) = Application.Transpose(arr3)
- End Sub
复制代码 |
评分
-
查看全部评分
|