FormulaR1C1 and abs. rel. referencing

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
 
D

Dave Peterson

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...
 
Top