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