Here is an issue giving me a little problem.
If I have a xls file called data.xls with Cells B2 and B3 (B2 hold the
value "[test.xls]" and B3 holds the value "ws'!$A$1").
If I have =B2 & B3 in cell A1, and cell B2 has [test1.xls] and cell B3
has ws'!$A$1,
I get [test1.xls]ws'!$A$1. I am trying to get =[test1.xls]ws'!$A$1.
notice the equal sign is not present on the first.
Is this possible? Any suggestions?
Thanks.
--
Jedidia
------------------------------------------------------------------------
Jedidia's Profile:
http://www.excelforum.com/member.php...o&userid=24694
View this thread:
http://www.excelforum.com/showthread...hreadid=382620