Multiple SUM's in a column
Hi Howard,
Am Thu, 6 Nov 2014 19:50:48 +0100 schrieb Claus Busch:
Sub MultiSum()
or:
Sub MultiSum2()
Dim i As Long, LRow As Long
Dim mySum As Double
With ActiveSheet
LRow = .Cells(Rows.Count, 3).End(xlUp).Row
For i = 2 To LRow + 1
If Len(.Cells(i, 3)) = 0 Then
.Cells(i, 3) = mySum
.Cells(i, 3).Font.Bold = True
mySum = 0
i = i + 1
End If
mySum = mySum + .Cells(i, 3)
Next
End With
End Sub
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|