Posted to microsoft.public.excel.programming

Kevin

external usenet poster

Posts: 134

Summing

How can I sum a range of cells in code. I have tried
myresult=Application.worksheetfunction.sum(Range(c ells
(2,1),cells(4,1))

but am having trouble. I get a syntax error.

Thanks!

Kevin

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
Summing it up	Violet 1	Excel Worksheet Functions	5	October 28th 08 08:57 PM
Summing 2 ifs	Steve	Excel Worksheet Functions	7	March 12th 08 03:11 PM
summing	Hasty	Excel Worksheet Functions	2	June 24th 07 04:31 PM
Summing	Catherine	Excel Worksheet Functions	4	April 26th 07 06:44 PM
PivotTable and summing/not summing	~Amanda~[_2_]	Excel Discussion (Misc queries)	1	March 14th 07 07:35 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us