|
I列 先计算I4单元格加I5单元格加I6单元格加I7单元格加I8单元格,再除以数字5后计算结果填入K9单元格
- Sub aaa()
- Dim arr, brr, i&, n&
- arr = Range("i4:i" & [i65536].End(3).Row)
- ReDim brr(1 To UBound(arr) - 4, 1 To 1)
- n = arr(1, 1) + arr(2, 1) + arr(3, 1) + arr(4, 1)
- For i = 5 To UBound(arr)
- brr(i - 4, 1) = (n + arr(i, 1)) / 5
- n = n + arr(i, 1) - arr(i - 4, 1)
- Next i
- [l9].Resize(UBound(brr)) = brr
- End Sub
复制代码
|
|