FormulaR1C1 and abs. rel. referencing

  • Thread starter Thread starter Hardy
  • Start date Start date
H

Hardy

Hi,

I've searched on this, but not found answer.

Using ActiveCell.FormulaR1C1, I want to fix some references, so I
activecell is B2, then RC[-1] will return A2 in formula, but how do
get it to return $A2 when the formula in placed into the spreadsheet
Also, how does one fix the row and also both.

Many thanks
 
rc1 will be the same row, column 1.
r2c2 will be $B$2

The square brackets indicate the relative position.

If you write some formulas in the worksheet using A1 reference style, you can
toggle to see the R1C1 reference style.

Tools|Options|General Tab
Check/uncheck R1C1 reference style

And you'll see it firsthand.

Hardy < said:
Hi,

I've searched on this, but not found answer.

Using ActiveCell.FormulaR1C1, I want to fix some references, so If
activecell is B2, then RC[-1] will return A2 in formula, but how do I
get it to return $A2 when the formula in placed into the spreadsheet?
Also, how does one fix the row and also both.

Many thanks,
Click to expand...
 
Back
Top