Sub 求和() Dim i As Integer Dim x As Integer x = Range("a65536").End(xlUp).Row For i = 2 To x Range("d" & i) = Application.Sum(Range("a" & i) : Range("c" & i)) Next i
Sub 求和() Dim i As Integer Dim x As Integer x = Range("a65536").End(xlUp).Row For i = 2 To x Range("d" & i) = Application.Sum(Range("a" & i) : Range("c" & i)) Next i