" wrote...
I am having a problem indirectly addressing a cell on a
second worksheet (that is open). I found this article
and when I tried the example it did now work similarly.

http://support.microsoft.com/?kbid=151323

When I simplified the example to indirect(a2) where a2
was '[book1.xls]sheet1'!a1 it also failed.

How did it 'fail'? Did it return #REF!, some other value that wan't equal to
that of '[book1.xls]sheet1'!A1, Excel wouldn't allow the formula to be entered,
what?

--
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.