Posted to microsoft.public.excel.programming

Rich[_16_] Rich[_16_] is offline

external usenet poster

Posts: 22

Newbie : How to sum cells via VBA code.

I am using Excel 97.

I want to sum the values of several cells. I tried to follow the
examples that I see in this forum and they don't work. My code looks
like :

lcRange is equal to B3:B35

ActiveCell.Value = "=sum(" & lcRange & ")"

I thought that the above command would sum up the values in a column
like an auto sum. But it does not work. Can anyone help me ? How can I
sum ???

Rich

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
[newbie] copy unhidden cells	Jon	Excel Discussion (Misc queries)	1	April 2nd 09 05:09 PM
Newbie Date cells so most recent is on top	[email protected]	Excel Worksheet Functions	1	May 14th 06 02:48 AM
VBA Newbie: Help with Do Loop code	Carl	Excel Discussion (Misc queries)	3	December 2nd 04 07:04 PM
Newbie : Help with sort via Excel code	Rich[_16_]	Excel Programming	1	January 10th 04 12:20 AM
Newbie : Autofilter thru code ?	Rich[_16_]	Excel Programming	2	October 5th 03 07:27 PM

All times are GMT +1. The time now is 07:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us