|
楼主 |
发表于 2017-6-28 09:48
|
显示全部楼层
- '.Cells(m + icount, 4) = Application.WorksheetFunction.Sum(.Range(Cells(m, 4), Cells(m + icount - 1, 4)))
- '.Cells(m + icount, 5) = Application.WorksheetFunction.Sum(.Range(Cells(m, 5), Cells(m + icount - 1, 5)))
- '改为:
- .Cells(m + icount, 4).Formula = "=Sum(R" & m & "C4:R" & m + icount - 1 & "C4)"
- .Cells(m + icount, 5).Formula = "=Sum(R" & m & "C5:R" & m + icount - 1 & "C5)"
复制代码 |
|