Version

CellReferenceMode Enumeration

Represents the various ways cells can be referenced in a formula.
Syntax
'Declaration
 
Public Enum CellReferenceMode 
   Inherits System.Enum
public enum CellReferenceMode : System.Enum 
Members
MemberDescription
A1Cells are referenced by first specifying characters representing the column and a one-based number specifying the row (R54 or CA56). The dollar sign ($) can preface one or both identifiers to make them absolute references ($A$7). Without the dollar sign, references still use absolute row and column addresses, although shifting a formula to a new cell will perform a similar shift on all relative references.
R1C1Cells are referenced in the following format R<RowIndex>C<ColumnIndex> (R34C5 or R2C345). These indices are one-based and represent absolute references. To create a relative reference in R1C1 mode, a relative index must be placed inside square brackets following the R and/or C ( R[-1]C[5] or R9C[-3] ). An R by itself also represents a relative reference and is equivalent to R[0]. Similarly, C is equivalent to C[0], which means a formula of =RC always references the cell which contains the formula.
Remarks

Setting this on the Workbook.CellReferenceMode will also affect the row and column labels.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also