Returns the text string of the contents of a given cell reference.
|ref_text||The reference to a range of cells.|
|a1||(Optional) Whether to return A1 or R1C1 reference notation:|
True = A1 notation is returned (default)
False = R1C1 notation is returned
|* For an illustrated example refer to the page under Advanced Formulas.|
* This function is Volatile and will change everytime a cell on the worksheet is calculated.
* This function will update when the workbook is recalculated by pressing F9.
* The "ref_text" can contain an A1-style reference, an R1C1-style reference, a named range, or a reference to a cell as a text string.
* If "ref_text" is not a valid cell reference, then #REF! is returned.
* If "ref_text" is a reference to a row (eg "3:3"), then the column containing the function is used.
* If "ref_text" is a reference to multiple rows then (eg "2:3"), then the column containing the function is used and an array is returned.
* If "a1" = True, then "ref_text" is interpreted as an A1 style reference.
* If "a1" = False, then "ref_text" is interpreted as an R1C1 style reference.
* If "a1" is left blank, then True is used.
* This function should be used when you want to change the reference to a cell within a formula without changing the formula itself.
* You can use the ADDRESS function to return the cell reference given a row and column number.
* You can use the COLUMNS function to return the number of columns in a cell range or reference.
* You can use the ROWS function to return the number of rows in a cell range or reference.
* This function can be used to always reference the same cells regardless of whether they are moved or copied.
* For the Microsoft documentation refer to support.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top