Q about referencing named ranges

[42N83W]

Windows XP Pro SP2
Excel 2002 SP3

Are the named ranges within a workbook accessible via the name alone, or do
you have to specify the sheet if the named range is on a sheet other than
the active sheet?

Does Excel allow the same named range if they reside on separate sheets?


-gk-

=================================================
The creative act is not the province of remote oracles or rarefied geniuses
but a transparent process that is open to everyone.
-Greg Kot in Wilco Learning How To Die-

 

[Nigel]

Named ranges can be global or local to specific sheets. So you can have the
same name for different sheets. IMO it is not a good idea and could cause
confusion!

 

[Bob Phillips]

You only have to specify the sheet if they are worksheet names as against a
workbook name. Worksheet names mean that the name can be re-used for
different sheets, using the same name, but referring to a different value.
To create worksheet names, precede the name by the sheet name, such as
Sheet1!MyName, in the Names dialog.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)