Sorry, should have added that my file Temp11.xls IS OPEN!
A1 contains "This is a test", co my B5 should also,




"Jim May" wrote in message
:

In Range A1:B3 of WorkBook2.xls I have:
A B
1 From Excel FileName: -- Temp11
2 From Sheet Name: -- Bob
3 From Cell Address: -- A1

In Cell B5

=INDIRECT(B1&$B$2&"!"&B3)

But currently B5 is showing #REF!

Can someone spot my problem?

TIA,