| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name Box
Is there a way to reference a cell named in one workbook in another?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
