Excel® 2013 VBA and Macros

5. R1C1-Style Formulas

In This Chapter

Referring to Cells: A1 Versus R1C1 References

Toggling to R1C1-Style References

The Miracle of Excel Formulas

Explanation of R1C1 Reference Style

Array Formulas Require R1C1 Formulas

Next Steps

Referring to Cells: A1 Versus R1C1 References

Understanding R1C1 formulas will make your job easier in VBA. You could skip this chapter, but your code will be harder to write. Taking 30 minutes to understand R1C1 will make every macro you write for the rest of your life easier to code.

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 ...