Formular1c1 attributes of VBA

Formular1c1 is the formula input method.
Brackets indicate the relative offset relative to the selected cell. "-" is the offset to the left or up, and the positive number is the offset to the right or down.
No brackets indicate the absolute offset relative to the selected cell, with no negative number.
"R" and "C" to be changed to "rows" and "columns"
For example, the selected cell is C8.
R [-1] C [-1] Is B7 cell, row and column are-1, R [1] C [2] is E9 cell, row + 1, column + 2
R1c1 indicates cell A1, and r5c6 indicates cell F5.

For example, cell C1 is "= A1 + B1"
Range ("C1"). formular1c1 = "= RC [-2] + RC [-1]"

For example, cell C1 is "= a2 + E3"
Range ("C1"). formular1c1 = "= R [1] C [-2] + R [2] C [2]"

Add absolute reference
For example, cell C1 is "= $ A $2 + $ e $3"
Range ("C1"). formular1c1 = "= r2c1 + r3c5"