Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum using r1c1 style
How do I sum using the R1C1 reference style?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum using r1c1 style
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? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ps.com... How do I sum using the R1C1 reference style? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum using r1c1 style
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 -- Regards, Tom Ogilvy " wrote: How do I sum using the R1C1 reference style? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using INDIRECT & R1C1 Ref style | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) |