Is this a bug?

excelos

Active Member
Joined
Sep 25, 2011
Messages
318
Hello

When I try to copy a sheet I get the following error, which no matter what I click, does not go away (it actually generates tons of such messages with different name)

i.ibb.co/BwffP3p/Capture.png

Any idea please?
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,042
Office Version
365
Platform
Windows
No it's not a "Bug"
You have named ranges on the sheet which are set to workbook scope and you can only have one instance of a workbook scoped name.
 
Last edited:

KOKOSEK

Board Regular
Joined
Apr 8, 2019
Messages
209
Office Version
365, 2013
Platform
Windows
Press Ctrl+F3 and check what ranges you've already named are in use.
 

excelos

Active Member
Joined
Sep 25, 2011
Messages
318
I clicked CTRL+F3 and I deleted all the names but it still does it!

It happens when I select and drag and drop a sheet's tab.

I have no idea is it on about, I have never specified the names it displays.

How do I fix that?
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,042
Office Version
365
Platform
Windows
It maybe that the names are hidden, try this
Code:
Sub excelos()
   Dim Nme As Name

   For Each Nme In ActiveWorkbook.Names
      Nme.Visible = True
   Next Nme
End Sub
Then go back into the name manager & delete the name
 

excelos

Active Member
Joined
Sep 25, 2011
Messages
318
mmm it fixed it, strange though as there is no indication of existing hidden names
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,042
Office Version
365
Platform
Windows
Glad it's sorted & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,697
Messages
5,470,228
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top