2.1.971 Part 1 Section 18.17.7.167, INDIRECT

a.   The standard does not place any length restrictions on argument ref-text.

Office returns #VALUE! if argument ref-text is more than 255 characters.

b.   The standard states the argument ref-text is of type A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a string.

Office allows argument ref-text to be type A1-style reference, an R1C1-style reference, a name defined as a reference, a structure reference, or a reference to a cell as a string.

Show: