"Sum" function as Macro

O

orenfarhi

hi there.
I'm new in this forum.
I want to simulate the button of auto SUM (sigma).
if in cells a1:a10 i have numbers.
in a11 i have the SUM function.
i the next 10 cells i have also numbers.
i want this macro to simulate the auto SUM button so it will calculate
from a12 till the one before him.
Thanks for all helpers. :)
 
S

Simon Lloyd

Not sure what your looking for exactly but this line will sum everythin
in the range you set (i've set it to be A14:E26) in to the cell A12

HTH

Simon

Range("A12").Select
ActiveCell.FormulaR1C1 = "=SUM(R[2]C:R[14]C[4])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Getting a Grand Total in Grand Total field only 3
using a variable in the sum function 3
Excel - Wich Function should I use? 1
sum a column with a variable 6
Sum Function When Formula Produces #N/A 2
Summing Percentages 3
Insert a function through a command button 5

Top