Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/gettings...
FormulaR1C1 is an excel formula notation that can be used in Excel VBA or Marcos.
By default, Excel uses the A1 reference style, Columns are letters (A XFD)
Rows with numbers (1 1048576).
In the R1C1 reference style,
Rows equal the Row Number
Columns Equal the Column Number
R1C1 Also inludes brackets for the Row or Column Reference
In this video we use the Imedaite window to show how R1C1 notation works.