Application.ReferenceStyle (Excel)

Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Possible return values are xlA1 - Default. Use xlA1 to return an A1-style reference, xlR1C1 - Use xlR1C1 to return an R1C1-style reference.

XlReferenceStyle can be one of these constants:

Application.ReferenceStyle = xlA1