To duplicate Sheet1 I highlighted the entire sheet using Control-A, then
used Control-C and
Control-V.

Ahh, well that's really not duplicating a worksheet. To do what I did you
simply hold Ctrl down and drag the sheet tab to the right or left (or
right-click the tab and select Move or Copy, which is slower). Make sure
you release the mouse button before you release Ctrl. Then you get all the
local names.

If you merely copy a range (even if it's the entire sheet's range) you just
get the names that are used in formulas. i.e., the names needed on the new
sheet for it to work.

--
Jim
"jmg092548" wrote
in message ...

Thanks, Jim. That's the behavior I'd expect also.

However - when I duplicated Sheet1 which had 64 names defined locally,
Excel only duplicated 29 of them to Sheet2. To duplicate Sheet1 I
highlighted the entire sheet using Control-A, then used Control-C and
Control-V.

I can't see any pattern to the 35 that weren't duplicated except that,
fortunately, they were all range names and not function names. It may
have helped that the function names were at the beginning of the list,
since they all started with an underscore. (However, it wasn't the last
35 that didn't get duplicated.)

Copying a sheet duplicates local names. I started with Sheet1 with
these
local names defined on it:

Sheet1!Range.1 =Sheet1!$C$7
Sheet1!Func.a =Sheet1!Range.1

The second name refers to the first as you seem to be doing. then I
copied
Sheet1 and renamed it to Sheet2 and on it were defined:

Sheet2!Range.1 =Sheet2!$C$7
Sheet2!Func.a =Sheet2!Range.1

So I had 4 names at this point.

--
Jim


--
jmg092548


------------------------------------------------------------------------
jmg092548's Profile:
http://www.excelforum.com/member.php...o&userid=26119
View this thread: http://www.excelforum.com/showthread...hreadid=395378