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