|
发表于 2015-4-24 09:31
|
显示全部楼层
本楼为最佳答案
本帖最后由 Excel学徒123 于 2015-4-24 09:50 编辑
- Sub 合计()
- Dim Irow As Integer
- Dim Inte As Integer
- Dim rg As Range
- Set rg = Cells.Find("合计", , , xlWhole)
- If Not rg Is Nothing Then
- rg.EntireRow.Delete
- End If
- Irow = Cells(Rows.Count, 2).End(3).Row
- Cells(Irow + 1, 2) = "合计"
- For Inte = 3 To 7
- Cells(Irow + 1, Inte) = Application.WorksheetFunction.Sum(Range(Cells(2, Inte), Cells(Irow, Inte)))
- Next
- End Sub
复制代码 楼下下载附件吧 |
|