Search notes:

Excel Object Model: Application.ConvertFormula

application.convertFormula converts converts range addresses of formulas between the two reference styles A1/R1C1 and/or between relative and absolute addresses.

The parameters of the function are:

`Formula`
`FromReferenceStyle`	`xlA1` or `xlR1C1`
`ToReferenceStyle`	`xlA1` or `xlR1C1`
`ToAbsolute`	`xlAbsolute`, `xlAbsRowRelColumn`, `xlRelative` or `xlRelRowAbsColumn`
`RelativeTo`	A `Range` object that has exactly one cell.

debug.print application.ConvertFormula("R4C9", xlR1C1, toReferenceStyle = x1R1C1)
$I$4

debug.print application.ConvertFormula("R4C9", xlR1C1, toReferenceStyle = x1A1)
$I$4

debug.print application.ConvertFormula("I4", xlR1C1, toReferenceStyle = x1R1C1)
'I4'

debug.print application.ConvertFormula("I4", xlR1C1, toReferenceStyle = x1R1C1, relativeTo = range("G3"))
'I4'

debug.print application.ConvertFormula("R[2]C[3]", xlR1C1, toReferenceStyle = x1R1C1, relativeTo = range("G3"))
L15

Excel Object Model: Application.ConvertFormula

See also