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 159 - Activecell.formulaR1C1 =


When you record a macro with a formula VBA for some reason will use the FormulaR1C1 property and use RC notation.

I normally change it, but the code will still work but might be a little unclear.

If you set the R1C1 values it's likely that the code was recorded.

Lets do the following:
  • Start Recording Macros (Alt L , R) Note: Developer Ribbon must be active
  • Enter the formula in cell A1 =A2+B2
  • Stop the Recorder
  • View the Code as it will look something like the following:

    Sub Macro13()

        ActiveCell.FormulaR1C1 = "=R[1]C+R[1]C[1]"
        Range("A3").Select
    End Sub


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