Private sub cmdUpdate_Click()

*other code*
Range ("E44") = Application.WorksheetFunction.Sum("F31:F38")
* other code*

End Sub

This line gives me a run-time error '1004' - Unable to get the Sum property
of the WorksheetFunction class.

I have no idea what this means or how to fix it.

If anyone could help, it is much appreciated.

Thanks

Hi Monique,

Try:

Range("E44") = Application.Sum(Range("F31:F38"))


---
Regards,
Norman



"Monique" wrote in message
...
Private sub cmdUpdate_Click()

*other code*
Range ("E44") = Application.WorksheetFunction.Sum("F31:F38")
* other code*

End Sub

This line gives me a run-time error '1004' - Unable to get the Sum
property
of the WorksheetFunction class.

I have no idea what this means or how to fix it.

If anyone could help, it is much appreciated.

Thanks

You need a range

Range ("E44") = Application.worksheetfunction.Sum(range("F31:F38") )

--
HTH

Bob Phillips

"Monique" wrote in message
...
Private sub cmdUpdate_Click()

*other code*
Range ("E44") = Application.WorksheetFunction.Sum("F31:F38")
* other code*

End Sub

This line gives me a run-time error '1004' - Unable to get the Sum
property
of the WorksheetFunction class.

I have no idea what this means or how to fix it.

If anyone could help, it is much appreciated.

Thanks

You need to supply the SUM function a range, not a string:

Range("E44") = Application.WorksheetFunction.Sum(Range("F31:F38") )



In article ,
"Monique" wrote:

Private sub cmdUpdate_Click()

*other code*
Range ("E44") = Application.WorksheetFunction.Sum("F31:F38")
* other code*

End Sub

This line gives me a run-time error '1004' - Unable to get the Sum property
of the WorksheetFunction class.

I have no idea what this means or how to fix it.

If anyone could help, it is much appreciated.

Thanks

Thanks for the advice.... Both suggestions worked...

"Monique" wrote:

Private sub cmdUpdate_Click()

*other code*
Range ("E44") = Application.WorksheetFunction.Sum("F31:F38")
* other code*

End Sub

This line gives me a run-time error '1004' - Unable to get the Sum property
of the WorksheetFunction class.

I have no idea what this means or how to fix it.

If anyone could help, it is much appreciated.

Thanks