ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "_Fill" and "_Key1" is contained in the worksheet I want to copy.. (https://www.excelbanter.com/excel-discussion-misc-queries/260792-_fill-_key1-contained-worksheet-i-want-copy.html)

CWP

"_Fill" and "_Key1" is contained in the worksheet I want to copy..
 
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?

Dave Peterson

"_Fill" and "_Key1" is contained in the worksheet I want to copy..
 
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.

CWP wrote:

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?


--

Dave Peterson


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com