Indirect and user selected workbook/worksheet
Posted by Fred on June 02, 2001 12:36 PM
Maybe the problem is simple, but I can't solve it.
In a file, let's call it File-A.xls, I have
Then, on the same page...
So, if I write "Sheet2" in A2, I have the content of sheet2 in A5.
THIS ONLY WORKS IF File-B is OPEN. If it's not, I have a #REF! error message.
I would like it to work even when the second file is closed. As it works with the address directly in the formula (=[TheFile.xls]theSheet!A1), it should also works here...
But I must be missing something.
Please, Help, Somebody... :-)