View Single Post
 
Old 01-23-2014, 11:02 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Actually, I agree with you for the purpose of ordinary Excel formulae. It's only because I do so much with VBA that I use R1C1 most of the time; for programming, it's much easier to think in.

It does have one other advantage. When we're talking about formulae on this forum, A1 notation requires one to explain the context when using relative references. That is, if I say the formula should be =SUM(C$2:C45), I have to explain as an aside that this is correct only when entered in C46. But in R1C1 I can just say =SUM(R2C:R[-1]C) and the location doesn't matter.

But, alas!, most people don't know R1C1 so it wouldn't be helpful to use it no matter how much clearer it is.
Reply With Quote