Is there a way to reference a cell named in one workbook in another?
L Luke M Dec 22, 2008 #2 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
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
