返回列表 上一主題 發帖

[發問] SUM VBA寫法請教

[發問] SUM VBA寫法請教

DEAR ALL大大
1 如圖一
Sheet44.Cells(M, 14) = Sheet44.Cells(M, 9) + Sheet44.Cells(M, 10) + Sheet44.Cells(M, 11) + Sheet44.Cells(M, 12) + Sheet44.Cells(M, 13)
1.1想改為  Sheet44.Cells(M, 14) =Application.SUM(...........)
2請問如何修改.煩不吝賜教   THANKS*10000

圖一
Sub TABCDE()
Sheet44.Select
Range("N1").Select
Sheet44.[N2:M65536].ClearContents
For M = 2 To 1000
If 1 = 1 Then
  Sheet44.Cells(M, 14) = Sheet44.Cells(M, 9) + Sheet44.Cells(M, 10) + Sheet44.Cells(M, 11) + Sheet44.Cells(M, 12) + Sheet44.Cells(M, 13)
End If
Next
End Sub
羅

DEAR  lpk187 大大
感謝您之指導.測試後完全符合需求 THANKS*10000
羅

TOP

Sheet44.Cells(M, 14) =Application.Sum(Range("I" & M & ":M" & M))

TOP

        靜思自在 : 【時間無法遮擋】怕時間消逝,花了許多心血,想盡各式方法要遮擋時間,結果是:浪費了更多時間,且一無所成!
返回列表 上一主題