on the other hand if the question was referring to "Defined Name"
you can have only one Defined Name with the same name in a workbook.

Any attempt to place a sheetname in front of the defined name will
get converted to the bookname.

You can have the same defined name in different workbooks
and include the workbook name before the exclamation point
if not in the same workbook.

value of A1 on sheet1 is 22 and has a defined name of _A1
value of A1 on sheet2 is 3

value formula as shown on Sheet2 for cells A1:A4
3 3
22 =_A1
22 =defined_name_2006_0313.xls!_A1
19 =_A1 - A1

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MartinW" wrote in message ...
If I'm understanding you correctly all you have to do is put the name of the
worksheet and an ! in front of your cell reference, i.e.

=Worksheet B!D5

will reference cell D5 in Worksheet B

HTH