|
发表于 2014-10-19 22:09
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, i&, j&, s&
- arr = Range("a3:b" & Cells(Rows.Count, 2).End(xlUp).Row)
- ReDim brr(1 To UBound(arr), 1 To UBound(arr) - 1)
- For i = 2 To UBound(arr)
- s = 0
- For j = i - 1 To 1 Step -1
- s = s + 1
- brr(i, s) = arr(i, 1) - arr(j, 2)
- Next
- Next
- Range("d3").Resize(UBound(brr), UBound(brr, 2)) = brr
- End Sub
复制代码 |
|