Reply to topic  [ 1 post ] 
INDIRECT worksheet function problem 
Author Message

Joined: Wed Sep 10, 2008 2:28 am
Posts: 1
Reply with quote
Post 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.

_________________
David.


Wed Sep 10, 2008 3:48 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.