The RC format is used in the Macro recorder when recording formulas.
The format is ..... I like to change the recorded code to use the Formula property and change the RC to A1 addressing. Record code as show example I enter a formula of =D9+D10 and VBA lists Activecell.FormulaR1C1 = "=RC[-1]+R[1]C[-1]" You can change the property to Formula and copy and paste the formula to your code. |