|
<< Click to Display Table of Contents >> ADDRESS (cell address as text) |
Syntax:
ADDRESS(Row, Column [, Abs] [, Mode] [, SheetName])
Description:
Returns a text string containing the address of a cell.
For row and column, the row number and column number of the cell must be specified.
The optional argument Abs specifies the type of reference to be returned:
1 or omitted: Absolute row and column
2: Absolute row, relative column
3: Relative row, absolute column
4: Relative row and column
The optional argument Mode specifies the format of the cell address returned:
TRUE or omitted: Normal cell address (e.g. A1)
FALSE: Cell address in R1C1 format (an alternative type of cell addressing, supported by Microsoft Excel only)
The optional argument SheetName lets you specify a worksheet name. If specified, it will be placed before the resulting cell reference In other words:
If it is not specified, only the cell address will be returned.
If it is specified, SheetName!Address will be returned (see example).
Example:
ADDRESS(1, 5) returns $E$1
ADDRESS(1, 5, 4) returns E1
ADDRESS(1, 5, 4, , "MySheet1") returns MySheet1!E1
See also: