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