DefineNames question
 

I am using XL 2002

I wrote all of the names in a workbook that I am working with to a text file and found a few entries like this

Network!ADSwitc

What does this meean? I've noticed that I only see the name 'ADSwitch' when I have the Network worksheet activated; otherwise it doesn't appear in the DefineNames dialog

TIA

JO

DefineNames question
 

Hi Joe,

I wrote all of the names in a workbook that I am working with to a text file and found a few entries like this:

Network!ADSwitch

What does this meean? I've noticed that I only see the name 'ADSwitch' when I have the
Network worksheet activated; otherwise it doesn't appear in the DefineNames dialog.

Names can be local (tied to a single sheet) or global (tied to the workbook).

It means that name is local to that particular sheet.
One creates a local name by preceding its name with the sheetname it is to be local to.

Another way local names get produced is when one copies a sheet with ranges that are referred to by global names.

If you use defined names a lot, consider downloading the
Name manager (by Charles Williams, Matthew Henson and
myself) from:

www.jkp-ads.com

or

www.bmsltd.ie/mvp

or from:

www.decisionmodels.com/downloads.htm


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

DefineNames question
 

Thank you, Jan

----- Jan Karel Pieterse wrote: ----

Hi Joe

I wrote all of the names in a workbook that I am working with to a text file and found a few entries like this
Network!ADSwitc
What does this meean? I've noticed that I only see the name 'ADSwitch' when I have the
Network worksheet activated; otherwise it doesn't appear in the DefineNames dialog

Names can be local (tied to a single sheet) or global (tied to the workbook).

It means that name is local to that particular sheet.
One creates a local name by preceding its name with the sheetname it is to be local to

Another way local names get produced is when one copies a sheet with ranges that are referred to by global names

If you use defined names a lot, consider downloading the
Name manager (by Charles Williams, Matthew Henson and
myself) from

www.jkp-ads.co

o

www.bmsltd.ie/mv

or from

www.decisionmodels.com/downloads.ht


Regards

Jan Karel Pieters
Excel MV
www.jkp-ads.co