On Sep 28, 2:37 pm, Gary''s Student
wrote:
Use INDIRECT. Something like:

=INDIRECT("[Book2]"& B1 & "!$B$2",TRUE)
where B1 contains:
Sheet1

Of course both books must be open
--
Gary''s Student - gsnu2007



Thanks. I tried this and I am almost there. The reason is I forgot
to mention that the value of the worksheet is caluclated off of a data
and not in a cell.

So I have no vlue in B1, but I do calculate the vlue of the worksheet
from a cell.

Is it possible to use a formula instead of a cell?

Thanks for all posts so far.

James