View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
42N83W 42N83W is offline
external usenet poster
 
Posts: 19
Default Q about referencing named ranges

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-