Skip to main content

Application.ConvertFormula method

Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. Variant.


expression.ConvertFormula (Formula, FromReferenceStyle, ToReferenceStyle, ToAbsolute, RelativeTo)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
Formula Required Variant A string that contains the formula that you want to convert. This must be a valid formula, and it must begin with an equal sign.
FromReferenceStyle Required XlReferenceStyle The reference style of the formula.
ToReferenceStyle Optional Variant A constant of XlReferenceStyle specifying the reference style that you want returned. If this argument is omitted, the reference style isn't changed; the formula stays in the style specified by FromReferenceStyle.
ToAbsolute Optional Variant A constant of XlReferenceType that specifies the converted reference type. If this argument is omitted, the reference type isn't changed.
RelativeTo Optional Variant A Range object that contains one cell. Relative references relate to this cell.

Return value



There is a 255 character limit for the formula.


This example converts a SUM formula that contains R1C1-style references to an equivalent formula that contains A1-style references, and then it displays the result.

inputFormula = "=SUM(R10C2:R15C2)"
MsgBox Application.ConvertFormula( _
    Formula:=inputFormula, _
    fromReferenceStyle:=xlR1C1, _

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>