Name Manager

[Utterly Bamboozled]

Can someone please help me unlock the mystery of the Name Manager?

I appreciate the Name Manager will include all names from all open workbooks, but in a workbook I've been working in there are names from models I haven't used in months and I can't seem to get rid of them.

Moreover, when I copy a sheet from one workbook to another (both being open), Excel tells me a name (that only exists in the destination workbook) already exists and do I want to use the definition of that name - i.e. the name Excel quotes has not been used in the sheet being copied across, nor in the source workbook.

I have tried some code to remove any names in the source worksheet before copying, but it hasn't done anything.

Thanks for any help!

UB

 

[shg]

there are names from models I haven't used in months and I can't seem to get rid of them.

What have you done to try? What happens?

 

[Utterly Bamboozled]

shg, with reference to names from models I haven't used in months I simply delete them but upon saving and re-opening they re-appear.

With reference to deleting names prior to copying to another workbook, I have tried:

For Each nm In Names
If nm.Parent.Name = ActiveSheet.Name Then nm.Delete
Next nm

Thanks for any help!

 

[shg]

Sub x()
    Dim oName As Name
    
    For Each oName In ActiveSheet.Names
        oName.Delete
    Next oName
End Sub

See the link in your other thread about removing names from worksheets that have apostrophes in their names.