Remember that this setting is for excel--not VBA.

Kind of close to the R1C1 reference style in VBA would be cells(x,y).

And it won't matter if you're in A1 or R1C1 style in your code when you do:

activesheet.range("a1").formula = "=b1+c1"

But it will matter if you tried:
activesheet.range("a1").formulaR1C1 = "=b1+c1"

because =b1+c1 isn't close to being R1C1 reference style.

=======
Personally, the only times I use R1C1 is:

1. If I want to know the column numbers some set of columns (and I don't want
to put =column() in any helper cell.

2. I want to see if my formulas are consistent. If you turn on r1c1, you can
usually just eyeball the formulas when you're going down a column to see if they
look the same. (Tools|Options|view|formulas is nice for this check, too.)



Stuart Grant wrote:

Can anyone tell me the advantages of using R1C1 cell references instead of
A1 - or point me to a web site dealing with it.

I changed one fairly large workbook to R1C1 but am finding a few
disadvantages - not all formulas or expressions seem to accept it - Range()
for instance.

Stuart

--

Dave Peterson