The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.
Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
That includes =indirect.ext() that may help you.
QuietMan wrote:
Does anyone mknow how I would reference "Sheet2" to a cell in a worksheet
Need to be able to change the worksheet name based on a cell
Thanks
='C:\Documents and Settings\FP&A\Templates\[SMP2Data.xls]Sheet2'!$A$1
--
Helping Is always a good thing
--
Dave Peterson