Returns the reference specified by a text string. References are
immediately evaluated to display their contents. Use INDIRECT
when you want to change the reference to a cell within a formula
without changing the formula itself. Ref_text is a reference to
a cell that contains an A1-style reference, an R1C1-style
reference, a name defined as a reference, or a reference to a
cell as a text string. If ref_text is not a valid cell
reference, INDIRECT returns the #REF! error value. - If ref_text
refers to another workbook (an external reference), the other
workbook must be open. If the source workbook is not open,
INDIRECT returns the #REF! error value. A1 is a logical value
that specifies what type of reference is contained in the cell
ref_text. - If a1 is TRUE or omitted, ref_text is interpreted as
an A1-style reference. - If a1 is FALSE, ref_text is interpreted
as an R1C1-style reference. The example may be easier to
understand if you copy it to a blank worksheet. How to copy an
example - Create a blank workboo