Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both.
There is a 255 character limit for the formula.
inputFormula = "=SUM(R10C2:R15C2)" MsgBox Application.ConvertFormula( _ formula:=inputFormula, _ fromReferenceStyle:=xlR1C1, _ toReferenceStyle:=xlA1)
The following arguments are required:
Possible Values are xlA1 - Default. Use xlA1 to return an A1-style reference, xlR1C1 - Use xlR1C1 to return an R1C1-style reference.
The following arguments are optional
ToReferenceStyle - 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