Is this a bug?

[excelos]

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?

 

[Fluff]

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.

 

[KOKOSEK]

Press Ctrl+F3 and check what ranges you've already named are in use.

 

[excelos]

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?

 

[Fluff]

It maybe that the names are hidden, try this

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]

mmm it fixed it, strange though as there is no indication of existing hidden names

 

[Fluff]

Glad it's sorted & thanks for the feedback