Search notes:

Office Object Model: Excel - Application.ReferenceStyle

Excel has two reference styles which can be chosen by assigning one of the two values xlA1 or xlR1C1 to application.referenceStyle.

Influence on column headers

With the A1 reference style in effect, Excel displays letters as column headers:
With R1C1 reference style, column numbers are displayed instead:

See also

The function application.convertFormula() converts range addresses (for example in formulas) between the two reference style and/or between relative and absolute addresses.
The returned value of range.address is not influenced by the currently active reference style.
SparklineGroups.add() can only be executed when the reference style is set to A1.

Index