I am trying to copy a sheet from one workbook into another. Both of these workbooks have hundreds of the same range names, but only maybe two (I mean two, not two hundred) exist on this sheet. Nevertheless, when I try to "copy worksheet", it wants to know which version of the range name I want to use for the hundreds of range names.

Does this make sense? Is copying one sheet from a workbook the equivalent of copying all its range names, even if, for sake of argument, none of them are referenced on that sheet?

Thanks!
Dean

I opened two workbooks in the same instance of Excel. The second book had
dozens of book-level named ranges as well as a few sheet-level named ranges.
I right-clicked on one sheet tab and selected "Move or Copy..." I copied the
sheet to the first book (check "Create a copy"). The sheet copied over and
only took it's local sheet-level named range with it. The book-level names
didn't copy over and I saw no prompt regarding which named range. (I also
tried this by adding a book-level name exactly the same as the sheet-level
name. Still no problem.) How are you doing the copy?

"Dean" wrote:

I am trying to copy a sheet from one workbook into another. Both of these workbooks have hundreds of the same range names, but only maybe two (I mean two, not two hundred) exist on this sheet. Nevertheless, when I try to "copy worksheet", it wants to know which version of the range name I want to use for the hundreds of range names.

Does this make sense? Is copying one sheet from a workbook the equivalent of copying all its range names, even if, for sake of argument, none of them are referenced on that sheet?

Thanks!
Dean

Just the way you are, Charlie. First of all, I did not know there was a
distinction of sheet level and book level range names. Assuming the range
that was named is all on one sheet, does that make it sheet level? If not,
kindly tell me what is the distinction.

This might be the problem - the sheet being copied might have had a
reference to another sheet (which, in turn, had references to another sheet,
which...) which might, ultimately, have 'covered' almost every range name in
the workbook.

Does this make sense?

Thanks!
Dean


"Charlie" wrote in message
...
I opened two workbooks in the same instance of Excel. The second book had
dozens of book-level named ranges as well as a few sheet-level named
ranges.
I right-clicked on one sheet tab and selected "Move or Copy..." I copied
the
sheet to the first book (check "Create a copy"). The sheet copied over
and
only took it's local sheet-level named range with it. The book-level
names
didn't copy over and I saw no prompt regarding which named range. (I also
tried this by adding a book-level name exactly the same as the sheet-level
name. Still no problem.) How are you doing the copy?

"Dean" wrote:

I am trying to copy a sheet from one workbook into another. Both of
these workbooks have hundreds of the same range names, but only maybe two
(I mean two, not two hundred) exist on this sheet. Nevertheless, when I
try to "copy worksheet", it wants to know which version of the range name
I want to use for the hundreds of range names.

Does this make sense? Is copying one sheet from a workbook the
equivalent of copying all its range names, even if, for sake of argument,
none of them are referenced on that sheet?

Thanks!
Dean

Hi Dean,

First of all, I did not know there was a distinction of sheet level and
book level range names. Assuming
the range that was named is all on one sheet, does that make it sheet
level? If not, kindly tell me what is the distinction.

See Jan Karel Pieterse' 'Defined Names' pages at:

http://www.jkp-ads.com/Articles/ExcelNames.htm

See also xlDynamic's Names page at:

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


---
Regards,
Norman

Nice links - thanks - this stuff does get complicated.


"Norman Jones" wrote in message
...
Hi Dean,

First of all, I did not know there was a distinction of sheet level and
book level range names. Assuming
the range that was named is all on one sheet, does that make it sheet
level? If not, kindly tell me what is the distinction.

See Jan Karel Pieterse' 'Defined Names' pages at:

http://www.jkp-ads.com/Articles/ExcelNames.htm

See also xlDynamic's Names page at:

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


---
Regards,
Norman