6. R1C1-Style Formulas
IN THIS CHAPTER
Referring to Cells: A1 Versus R1C1 References
Switching Excel to Display R1C1-Style References
Referring to Cells: A1 Versus R1C1 References
We can trace the A1 style of referencing back to VisiCalc. Dan Bricklin and Bob Frankston used A1 to refer to the cell in the upper-left corner of the spreadsheet. Mitch Kapor used this same addressing scheme in Lotus 1-2-3. Upstart Multiplan from Microsoft attempted to buck the trend and used something called R1C1-style addressing. In R1C1 addressing, the cell known as A1 is referred to as R1C1 because it is in Row 1, Column 1.
With the dominance of Lotus 1-2-3 ...
Get VBA and Macros: Microsoft® Excel® 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.