Excel 2016 VBA and Macros

5. R1C1-Style Formulas

In This Chapter

Referring to Cells: A1 Versus R1C1 References

Toggling to R1C1-Style References

Witnessing the Miracle of Excel Formulas

Understanding the R1C1 Reference Style

Using R1C1 Formulas with Array 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 if you do, 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 ...