Name Box
Sure can!
Example:
='C:\My Documents\[Book1.xls]Sheet1'!$A$1
or if you mean a named cell (say, MYRANGE),
='C:\My Documents\[Book1.xls]Sheet1'!MYRANGE
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"newguy" wrote:
Is there a way to reference a cell named in one workbook in another?
|