Sum using r1c1 style

  • Thread starter Thread starter Pdauwe
  • Start date Start date
Numbers in A1:A5
In C3 I had =SUM(A1:A5)
When I switch to R1C1 style this becomes =SUM(R[-4]C[-2]:R[-1]C[-2])
R[-4] means 4 rows above current cell; C[-2] means 2 columns to left of
current cell, etc.
Any help?
 
ActiveCell.FormulaR1C1 = "=Sum(R1C1:R10C1)"

If you mean in VBA, you can use

Activecell.Value = Application.Sum(Range(cells(1,1),Cells(10,1)))

the row column references are like absolute R1C1 - but you can't literally
use R1C1 addressing

You can take a look at the Application.FormulaConvert function
 

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 do I use r1c1 notation in excel? just doing "=r2c3" not work 4
help on Converting R1C1 to A1 and A1 to R1C1..tia sa2 3
R1C1 reference style as default while opening Excel 3
refer to a particular cell in r1c1 style 11
Turn off R1C1 reference style via VBA 1
How to code with the R1C1 Style of Reference? 3
Excel formula in VBA 2
Why R1C1 range parameters in VBA Pivot Table setup/ 18

Back
Top