Application.ConvertFormula method (Excel)

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, _ 

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.