Worksheetfunction help

[Glen Mettler]

This gives me an error. What have I done wrong?
sRow=6
newval = Application.WorksheetFunction.Sum("ah" & sRow & "D" & sRow)

Glen

 

[Otto Moehrbach]

Glen
You can't just put in a range address like you can when you use the Sum
formula in a worksheet. You must state that this is a range. Something
like:
newval = Application.WorksheetFunction.Sum(Range("ah" & sRow & "D" &
sRow))
HTH Otto

 

[Arvi Laanemets]

Hi

To which worksheet you are referring to? Try MS Help example as muster:
....
sRow=6
myRange=Worksheets("Sheet1").Range("AH" & sRow & "D" & sRow)
newval=Application.WorksheetsFunction.Sum(myRange)


Arvi Laanemets

 

[Glen Mettler]

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

Thanks
Glen

 

[Myrna Larson]

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

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