=INDIRECT("'"&E2&"'!"&E7)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite"
wrote in message
...

Hiya guys and gals

I have the following code;

=INDIRECT("E2"!, E7)

From what i understand from the help files this should work, unless i
am being stupid (highly probable)

What I want it to do is for the host cell to display the value of cell
E7 from another worksheet, the name of the work sheet is in cell E2.

Like i said i have searched the help files and this seems to be the
method that is best.

Regards
James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=515417