|
页数 | 结果 | 1 | 1 | 5 | 5 | 1 | 1 | 21 | 21 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | 32 | 1 | 1 | 5 | 5 | 1 | 1 | 21 | 21 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | 32 | 1 | 1 | 5 | 5 | 1 | 1 | 20 | 20 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | | 32 | 左边是情况,右边是想要的结果,我知道alt+"+"可以做到,但我更想要代码{:021:}求高手
本帖最后由 today0427 于 2016-12-22 21:23 编辑
- Sub today()
- Dim i&, n&, arr
- arr = Range("g2:g" & [g65536].End(3).Row + 1)
- For i = 1 To UBound(arr)
- If arr(i, 1) <> "" Then
- n = n + arr(i, 1)
- Else
- arr(i, 1) = n: n = 0
- End If
- Next
- Columns("i:i").Clear
- [i2].Resize(i - 1, 1) = arr
- End Sub
-
复制代码
空单元格求和.rar
(27.3 KB, 下载次数: 3)
|
|