| | | 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 . |
| | | This function can be used to always reference the same cells regardless of whether they are moved or copied. |
| | | For working example of how to reference cells indirectly please refer to the Referencing Cells Indirectly page. |
