EasyXLS
http://forum.easyxls.com/

INDIRECT worksheet function problem
http://forum.easyxls.com/viewtopic.php?f=5&t=730
Page 1 of 1

Author:  david [ Wed Sep 10, 2008 3:48 am ]
Post subject:  INDIRECT worksheet function problem

Trying to evaluate the following kind of formulae:
Code:
INDIRECT(B2)
SUM(INDIRECT(B2))

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.

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/