Which reference style is best? R1C1 or A1?

[Jon von der Heyden]

I'd say about 99% of formulas posted on this board use A1 reference style. But the more I use R1C1 the more I like it.

So, which reference style do you find better, and why?

 

[Jon von der Heyden]

Just to be clear I'm referring to benefits using the reference style in your workbook, not what you use in VBA.

I have gone for R1C1. Although at the moment my default is on A1 I think I'm going to move to R1C1. The way I see it, if I want to refer to a cell by it's position on the grid then I should use a absolute reference. Otherwise generally I find it better to refer to a cell by it's relative position...

 

[RoryA]

Statistically speaking, only sociopaths use R1C1 style in the main UI.

 

[shg]

Too many brackets to type.

 

[T. Valko]

A1 all the time.

This just doesn't look cool:

=SUM(R[660320]C[14941]:R[660329]C[14941])

 

[SydneyGeek]

A1 for the worksheet. But definitely R1C1 for VBA.

Denis

 

[Richard Schollar]

I agree with all the above. A1 all the way in the worksheet

 

[Sandeep Warrier]

A1 for me too ... I find that at times R1C1 gets too confusing!

 

[Domski]

A1 all the way you nutter

Dom

 

[yytsunamiyy]

unless somebody stands behind me with a very big stick - A1