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

See also

The application object of Excel's object model.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Microsof...', 1758194331, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Microsoft/Office/Excel/Object-Model/Application/convertFormula(64): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78