
INDIRECT worksheet function problem
Trying to evaluate the following kind of formulae:
where B2 contains text like "Sheet2!A1:A15" or only even "A1:A15".
For both cases (same sheet and different sheet) Excel evaluates to the correct Values, whereas EasyXLS evaluates to a #VALUE error.
How can that be fixed?
Thanks in advance.