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!

--
Cheers
Nigel



"42N83W" wrote in message
...
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-