Brym,

I personally find the R1C1 notation much easier if you are using variables.
For instance,if I creating a formula that sums this row, column A to the
column immediately to the left of this column I simply do

ActiveCell.FormulaR1C1 = "=SUM(RC1:RC[-1])"

whereas in A1 notation I need
With ActiveCell
.Formula = "=SUM(A" & .Row & ":" & Chr(.Column - 1 + 64) & .Row &
")"
End With

and it gets even more complex.

--

HTH

Bob Phillips

"brym" wrote in message
...
Hi! I'm a little puzzled why Excel macro recording in some situations is
using R1C1 notation.
Is there any benefit using that notation type?

And, as I've never really worked with that notation, it sometimes give me
problems.

Especially when trying to use variables to describe a range.

Does a 'translation'-description or other help exist somewhere? Haven't
been
able to find one!

Thanks in advance
Birger