Posted to microsoft.public.excel.programming

Monique

external usenet poster

Posts: 60

worksheetfunction.sum error

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application.WorksheetFunction error	Ayo	Excel Discussion (Misc queries)	4	May 16th 08 05:04 PM
Worksheetfunction.vlookup and #value error	BL	Excel Worksheet Functions	2	June 17th 05 09:48 PM
Error '1004' in WorksheetFunction	oakman[_16_]	Excel Programming	0	November 18th 04 01:48 PM
Error '1004' in WorksheetFunction	oakman[_15_]	Excel Programming	1	November 17th 04 08:16 PM
Error '1004' in WorksheetFunction	oakman[_14_]	Excel Programming	1	November 17th 04 03:56 PM

All times are GMT +1. The time now is 05:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us