ExcelBanter - Name Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Name Box (https://www.excelbanter.com/excel-discussion-misc-queries/214451-name-box.html)

newguy

Name Box

Is there a way to reference a cell named in one workbook in another?

Luke M

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?

All times are GMT +1. The time now is 07:06 PM.