| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA and creating a Macro | Excel Discussion (Misc queries) | |||
| Creating a macro | Excel Programming | |||
| Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
| Need Help Creating A Macro | Excel Worksheet Functions | |||
| help creating a macro | Excel Programming | |||
Linear Mode
