Named ranges exist at either the Workbook level or the Worksheet level.


For instance, you could have a range named "myWorkbookRange" which,
when viewed in the Define Name window, will not display text to the
right of the range name. You can access those names from anywhere in
the workbook by using EditGoto or the Name Box (at the upper left of
the workbook).

Alternatively, you could create a Sheet level range name by prepending
the name of the worksheet to the range name:
InsertNameDefine
Name: Sheet2!mySheetRange
Refers to: =Sheet2!$A$1:$D$10

As soon as you click the [Add] button, you'll see the sheet reference
displayed to the right of the range name. Also, that name will only be
visible in the Go To window and the Name Box when Sheet2 is selected.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=383680