Macro that adds all numbers that have formulas
Very good Rick.
Thanks.
Gord
On Sun, 31 Jan 2010 23:01:38 -0500, "Rick Rothstein"
wrote:
What about modifying your code this way...
Sub sum_formulas_only()
Dim rng As Range, rng1 As Range, rng2 As Range, AddressSum As String
Set rng = Range("C1", Cells(Rows.Count, 3).End(xlUp))
Set rng1 = rng.SpecialCells(xlCellTypeFormulas)
For Each rng2 In rng1
AddressSum = AddressSum & "+" & rng2.Address(0, 0)
Next
rng(rng.Count).Offset(2, 0).Formula = "=" & Mid(AddressSum, 2)
End Sub
|