Sheet Level Names

  • Thread starter Thread starter Keith Young
  • Start date Start date
K

Keith Young

How can I use the same name to define ranges on several different sheets?

For example, I already have a named range on "Sheet X" called 'rng'. How do
you use 'rng' for named ranges that will be on "Sheet Y" and "Sheet Z"? Can
this need to be done through the Define Name dialog box or can it only be
done using code?

Thanks in advance. Keith
 
Hi Keith,

You can define local names using the Define Name dialog box:
select sheet Y and the name is for example
'Sheet y'!rng

and the refersto is for example
='Sheet Y'!a44+Globals!Z44

You can only see the local names when the local sheet is active.

It is not a good idea to have both a global name called rng and a local name
called rng

If you are going to be using defined names a lot i recommend downloading
Name Manager (developed by jan karel pieterse and myself) from my downloads
page. It allows you to convert names from global to local etc.

http://www.DecisionModels.com/downloads.htm

Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com
 
Back
Top