Hi,
the submitter of issue 105182 closed the issue, because he find a way to
solve his problem. But for me the situation is not clear.
=ISREF(D1:D3!C2:E2) returns TRUE
but
=ISREF(INDIRECT("D1:D3!C2:E2")) returns FALSE
=ISREF(A1~B1) returns TRUE
but
=ISREF(INDIRECT("A1~B1")) returns FALSE
And INDIRECT("(A1:C3):(B2:D4)") fails too.
Are expressions as text not allowed for INDIRECT or are they allowed but
not implemented yet?
And same with issue 104969, References to external sheets not allowed or
allowed but still need to be implemented?
And what about all type of names? INDIRECT("name") will fail. I know,
that is mentioned in the help. But must it fail?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
