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...
 
You must log in or register to reply here.

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

Combine 2 columns in a dynamic range into one 7
Copying Data Down the Column But Only Based on What's in Column A 1
addressing type in FormulaR1C1 1
relatetive reference-to perform a series of cal and return result 2
.Formula vs .FormulaR1C1 in 2007 5
VBA Compare part of cell to another cell and then calculate 0
FormulaR1C1 not working 2
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1

Back
Top