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"