" wrote...
I'm sorry - it failed with a #ref in the function. The
example as I understand it should have resulted in "This
is a test" in In Book2, Sheet1, cell B1

I'm going to guess that Book2 hasn't been saved, so it doesn't have a file
extention. Try entering

[book2]Sheet1!B1

in cell A2 of the active worksheet in the active workbook. Then try

=INDIRECT(A2)

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.