[發問] SUM VBA寫法請教

rouber590324

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

rouber590324

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