That just proves that all self-certified "gurus" aren't <g. It should say

WorksheetFunction.Sum(Range("A1:J4"))

On Wed, 9 Feb 2005 14:27:41 -0600, "Glen Mettler"
wrote:

Interesting. The example I have from an Excel "Guru" book shows
"WorksheetFunction.Sum("A1:J4")

Thanks
Glen

"Glen Mettler" wrote in message
...
This gives me an error. What have I done wrong?
sRow=6
newval = Application.WorksheetFunction.Sum("ah" & sRow & ":DD" & sRow)

Glen