"_Fill" and "_Key1" is contained in the worksheet I want to copy..

C

CWP

We are trying to copy a worksheet in Excel and we get the notice that the
sheet we are trying to copy contains the name '_Fill' and '_Key1' which
already exists on the destination worksheet. There are no named ranges, no
set print ranges, no macros. We have no idea what these refer to. What are
they?
 
D

Dave Peterson

I don't think that these are built-in names that excel uses. (At least through
xl2003.)

But names can be hidden -- even names that refer to ranges.

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It's the best tool I've seen for working with names.

You'll be able to see names (hidden or visible) and even hide/unhide them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

We try to save msg in got the error in outlook 2021/office 365 0
Cannot copy worksheet to another file 2
Change the "From" email address VBA 0
Doughnut Chart linked with the slicer in the pivot table 0
Visio shape text disappears upon copy paste 1
'copy or move' name conflict 3
Embedded Excel into Word with Tables 0
why the macro is not included in the list? 3

Top