Creates a cell address as text, given specified row and column numbers.
Syntax
ADDRESS(row_num,column_num,abs_num,a1,sheet_text)
Row_num is the row number to use in the cell reference.
Column_num is the column number to use in the cell reference.
Abs_num specifies the type of reference to return.
|
Abs_num |
Returns this type of reference |
|
1 or omitted |
Absolute |
|
2 |
Absolute row; relative column |
|
3 |
Relative row; absolute column |
|
4 |
Relative |
A1 is a logical value that specifies the A1 or R1C1 reference style. If a1 is TRUE or omitted, ADDRESS returns an A1-style reference; if FALSE, ADDRESS returns an R1C1-style reference.
Sheet_text is text specifying the name of the worksheet to be used as the external reference. If sheet_text is omitted, no sheet name is used.
Examples
ADDRESS(2,3) equals "$C$2"
ADDRESS(2,3,2) equals "C$2"
ADDRESS(2,3,2,FALSE) equals "R2C[3]"
ADDRESS(2,3,1,FALSE,"[Book1]Sheet1") equals "[Book1]Sheet1!R2C3"
ADDRESS(2,3,1,FALSE,"EXCEL SHEET") equals "'EXCEL SHEET'!R2C3"