Simple Excel VBA question: How do I sum a range of cells?

  • Thread starter Thread starter Lazer
  • Start date Start date
L

Lazer

This is *bad* syntax:
Range("C" & currentOutputRow).Formula = Sum(Range("C"
firstRowContainingDataInOutputWorksheet, "C" & currentOutputRow - 1))

What is the proper syntax for summing a range?

Thanks!
Laze
 
Hi
what are you trying to achieve?
- Do you want to insert a formula in your cell
- do you want to sum a range and return the result to a variable in VBA
to further process this value
 
Would this work for you?

ActiveCell.FormulaR1C1 = "=Sum(R1C:R[-1]C)"
 
Range("C" & currentOutputRow).Formula = _
"=Sum(C" &
firstRowContainingDataInOutputWorksheet &
":C" & currentOutputRow - 1 & ")"
 
You must log in or register to reply here.

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

Slow code operation when refering to different sheets 2
Sum a variable length column 1
Variable SUM range 16
Multiple SUM's in a column 15
Sum a range of cells based on relative position 3
Excel VBA 1
Need Macro to Sum Range and Paste the Value into one Cell 2
Better Understanding 4

Back
Top