Need help in creating sum macro
 

Hi,

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

Can anyone help me out? I am totally new to macros.

Thanks

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