你的意思是不是说求某一列,这里就是求T列。在这一列中的空格内填上,前面连续的非空的和?我是这样理解的,我重新写了段代码。- Sub zhoucs00()
- Dim k As Integer, t As Integer, rng As Range, rg As Range
- k = Range("b65536").End(xlUp).Row + 1
- t = Application.InputBox("请输入数字", , , , , , , 1)
- Set rg = Cells(1, t)
- For Each rng In Range(Cells(1, t), Cells(k, t))
- If Len(rng) = 0 Then
- rng = Application.WorksheetFunction.Sum(Range(rg.Address, rng.Offset(-1, 0)))
- Set rg = rng.Offset(1, 0)
- End If
- Next rng
- End Sub
-
复制代码
图纸材料统计表-0106.rar
(65 KB, 下载次数: 0)
|