Maybe columns E, F or G extend farther down than column D.

As written you will be summing D1:Gr with r being last row in column D


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 16:00:02 -0800, Steved
wrote:

Hello Gary from Steved

If I sum each Col and the sum the 4 Columns I get 1462003

If I use Application.WorksheetFunction.Sum(Range("D1:G" & r)) I get 1208502.

Is there something I'm doing.

Thankyou.

"Gary Keramidas" wrote:

just change the 2nd D to a G

Application.WorksheetFunction.Sum(Range("D1:G" & r))


--


Gary


"Steved" wrote in message
...
Hello from Steved

Below will sum Col D How would I get it to sum D:G please

Sub AddSum()
r = Range("D65536").End(xlUp)
MsgBox "SUM:" & _
Application.WorksheetFunction.Sum(Range("D1:D" & r))

End Sub

Thankyou.