When you do Insert|name|Define, you get a dialog where you can enter the name of
the range and what it refers to.

If you put the sheet name in that "names in workbook" box, like:

Sheet1!Test
or
'Sheet 22 of 23'!Test

Then you've created a sheet level name.

Did you do it this way?

And xl97 to xl2003 have worked the same way.

I put this in the other branch of the thread, too...

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

(It's much easier to use that then the built in Insert|Names dialog.)

"Bill Martin -- (Remove NOSPAM from address)" wrote:

Bob Phillips wrote:
Not correct Bill.

See http://www.xldynamic.com/source/xld.Names.html


-----------

I'm a bit confused (a common state). Is this global/local span something which
has changed with Excel versions? In my Excel97 I don't seem to have cell names
local to a sheet as your web page describes. The following steps illustrate:

1) define a cell to be named "Test" and verify I can access the cell using that
name from that sheet.

2) go to another sheet and define a cell to be named "Test" and verify I can
access the cell using that name.

3) go back to the first sheet, and the name "Test" now links to the cell on the
second sheet -- even when used in the first sheet.

4) go into insertnamedefine and I see that Excel only shows one cell by that
name and it's linked to the second sheet (most recently created link).

Am I somehow creating the name incorrectly for local use, or does my Excel97
behave differently from your version? Or have I totally misunderstood?

Thanks...

Bill

--

Dave Peterson