Duplicate named ranges

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

Is it possible to have duplicate named ranges in a
workbook? I am using Excel 2000 on a Windows 2000 system.
I can acheive creating a duplicate named range in a
workbook by doing a copy sheet into the same workbook but
I am unable to create multiple named ranges in the ame
workbook by other means. When I try to define the named
ranges I get directed to the last copy defined. Is there a
way around this?
TIA
George
 
George,

You can have workbook names that apply to the whole workbook, and worksheet
names that only apply to that sheet and can be replicated on each sheet. To
create the latter, precede the name by the sheet name when adding it in
Insert>Name>Define..., such as Sheet3!localName.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top