difference between formula and formulaR1C1

[y2k1981]

can somebody tell me in excel what the difference is between formula and formulaR1C1???

tried searching here and on google but came up with nothing

thanks in advance

 

[Nelviticus]

Well, according to the VBA help files the difference is in how you write the formula. The example line for FormulaR1C1 is:

Worksheets("Sheet1").Range("B1").FormulaR1C1 = "=SQRT(R1C1)"

and for Formula it's:

Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"

so it's just down to how you reference the cells - the second row on the second column is either "R2C2" or "B2" depending which method you use.

N.

 

[TonyJollans]

Hi y2k1981,

The differenec between the two properties is in the reference style used. If you don't know the difference I suggest you review the Help, but briefly ..

A1 style references use letters for columns and R1C1 style references use numbers.
A1 style references are absolute and R1C1 style references can be relative.

To see the difference, put a simple formula in a cell, for example in cell A2 put &quot;=A1&quot;; switch to formula view (<CTRL><`>) then use Tools > Options > General > R1C1 Reference style to switch between the two styles.

Enjoy,
Tony