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