View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BEEJAY BEEJAY is offline
external usenet poster
 
Posts: 247
Default Named Range: Same Names, Multiple Workbooks with Same Sheet Name

1: (will) have massive amounts of coding with Named Ranges.

Multiple WorkBooks, each having a sheet called "PRICE" and each having
multiple range names that are identical (although physical range would be
different).
Assume 2 or more workbooks are OPEN.
Is there any possibility that under any circumstances a range name can be
"picked up" from an open (but not active) workbook?

2: Based on the knowledge from the experts out there, even if there is no
problem as regards # 1, above, would it still be wise to custom name each
range name, based on the workbook it is in?

Thanks for your input in advance.