"_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

Cannot copy worksheet to another file 2
'copy or move' name conflict 3
Setting Scope of name ranges to particular worksheet 2
Conditional formatting when text is contained in a named range 2
Copy to another worksheet 3
copy/paste want to retain cell coloration but lose the conditional formatting source data 6
Causes of "A...sheet you want to move...contains "wrn.BCOMP"? 1
ERROR 2

Top