Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

There are three ways to address cells, areas, and ranges using ExcelApplication:

Anchor
A1
A1

Excel's A1 Reference Style

...

The reference style used in the generated workbook (when it is opened in Excel) is determined by the value of the property Workbook.UseRCFormulaNotation. If it is false (the default value), Excel will use A1 references. If UseRCFormulaNotation is set to true, Excel will use R1C1-style references.

Anchor
R1C1
R1C1

...