FormulaR1C1 Property In Excel VBA (In Easy Steps)

Trang chủ » C Vba » FormulaR1C1 Property In Excel VBA (In Easy Steps)

Có thể bạn quan tâm

FormulaR1C1 in Excel VBA

This example illustrates the difference between A1, R1C1 and R[1]C[1] style in Excel VBA.

1. Place a command button on your worksheet and add the following code line (A1 style):

Range("D4").Formula = "=B3*10"

Result:

A1 Style

2. Add the following code line (R1C1 style):

Range("D4").FormulaR1C1 = "=R3C2*10"

Result:

R1C1 Style

Explanation: cell D4 references cell B3 (row 3, column 2). This is an absolute reference ($ symbol in front of the row number and column letter).

3. Add the following code line (R[1]C[1] style):

Range("D4").FormulaR1C1 = "=R[-1]C[-2]*10"

Result:

R[1]C[1] Style

Explanation: cell D4 references cell B3 (one row above and 2 columns to the left). This is a relative reference. This code line gives the exact same result as the code line used at step 1.

4. Why learning about this? Because the Macro Recorder uses the FormulaR1C1 property (R[1]C[1] style). The Macro Recorder creates the following code lines if you enter the formula =B3*10 into cell D4.

Excel Macro Recorder Result

Explanation: you can see that this is the exact same code line used at step 3.

6/9 Completed! Learn much more about creating macros ➝Next Chapter: MsgBox

  • Chapter
    • Create a Macro

  • Learn more, it's easy

    • Swap Values
    • Run Code from a Module
    • Macro Recorder
    • Use Relative References
    • FormulaR1C1
    • Add a Macro to the Toolbar
    • Enable Macros
    • Protect Macro

  • Download Excel File

    • formulaR1C1.xlsm
  • Next Chapter
    • MsgBox

Follow Excel Easy

Excel Easy on Facebook Excel Easy on X Excel Easy on Pinterest Excel Easy on LinkedIn

  • Become an Excel Pro

    • 1. Introduction
    • 2. Basics
    • 3. Functions
    • 4. Data Analysis
    • 5. VBA

FormulaR1C1 • © 2010-2025 December 2025 Highlights: Calendar • Holidays • Gantt Chart • Regression • Find Duplicates

Từ khóa » C Vba