feel free to take that as a rhetorical question

Great, I will! Since it's unanswerable<g. Even the most experienced users
have faulty assumptions in their Excel mental toolset. I guess you have to
be alert to recognize when something that should happen if your assumptions
are true doesn't, to immediately challenge your assumptions. Easier said
than done.<g

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

Jim,

Thank you VERY much! That solves my problem.

I was about to ask "How does one learn this kind of in-depth info about
Excel?" and then I looked in Excel's help file and it said that's the
way to copy a worksheet (via Ctrl-drag, or from the "Edit - Move or
Copy Sheet" menu.)

So my assumption was the root of the problem, that copying a range
(consisting of the entire sheet) was the same as copying the sheet.

So how does one learn enough to avoid making faulty assumptions like
that?? :) ... feel free to take that as a rhetorical question,
but if you have suggestions I'd be quite open to hearing them!

Thanks again,

Jim


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


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