|
发表于 2009-10-30 15:13
|
显示全部楼层
本楼为最佳答案
Sub Hebing() Application.ScreenUpdating = False Sheet1.Range("F:F").Clear For i = 1 To Sheet1.Range("J1:M65536").Find("*", Range("J1"), , , xlByRows, xlPrevious).Row Sheet1.Range("F" & i) = WorksheetFunction.Sum(Range(Cells(i, 10), Cells(i, 13))) If Sheet1.Range("F" & i) = 0 Then Sheet1.Range("F" & i).Clear Next i Application.ScreenUpdating = True End Sub |
|