The below would refer to the first cell of named range Name1 from saved
workbook Mybook.xls

=INDEX(MyBook.xls!Name1,1)

--
Jacob


"Vixter" wrote:

P.S. It's not just using the same name. I need to use the same ranges as the
two workbooks are connected.

"Vixter" wrote:

I have one workbook where I have named ranges.
Is it possible to somehow use those names in formulas in a completely
different workbook? Excel 2003.
Any help is appreciated.