Menu

Need help in creating sum macro

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Claus Busch Claus Busch is offline

Claus Busch is offline

external usenet poster

Posts: 3,872

Default

Need help in creating sum macro

Hi,

Am Sat, 7 May 2016 01:12:58 -0700 (PDT) schrieb
:

I need to create Macro of addition for example.
Data is available in Column C4 to c34.
The answer should display at C35.

why don't you use SUM function in the sheet?
If you want a mcro, try:

Sub Test()
Range("C35") = Application.Sum(Range("C4:C34"))
End Sub

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
VBA and creating a Macro	tommy	Excel Discussion (Misc queries)	4	January 28th 09 03:52 PM
Creating a macro	Midas[_2_]	Excel Programming	1	February 8th 06 04:51 PM
Creating a macro which presses a button containing a recorded macro	petros89[_3_]	Excel Programming	3	October 5th 05 02:49 PM
Need Help Creating A Macro	LJ Owen	Excel Worksheet Functions	1	March 2nd 05 01:52 PM
help creating a macro	ale700	Excel Programming	3	July 6th 04 05:37 AM

All times are GMT +1. The time now is 07:17 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement