By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 104 - Activecell.FormulatR1C1


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.

   Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit