Thread: Name Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?