- Sub aaa()
- Dim arr, brr, i&, j&, d As Object, d1 As Object
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- [f1].CurrentRegion.Offset(1, 1).ClearContents
- arr = [f1].CurrentRegion
- brr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = i
- Next i
- For j = 2 To 4
- d1(arr(1, j)) = j
- Next j
- For i = 2 To UBound(brr)
- arr(d(brr(i, 1)), d1(brr(i, 2))) = arr(d(brr(i, 1)), d1(brr(i, 2))) + brr(i, 3)
- arr(d(brr(i, 1)), 5) = arr(d(brr(i, 1)), 5) + brr(i, 3)
- Next i
- [f1].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |