"Name" query

[skaxamax]

I have a spreadsheet that I got hold of a few years back and have modified over time and always encountered the following problem with it. When I copy a worksheet (create a copy) in the file I am told

"A formula or sheet you want to move or copy contains the name "XXXX' which already exists on the destination worksheet. Do you want to use this version of the name?

* To use the name as defined in the worksheet click yes
* To rename the range referred to in the worksheet , click no and enter a new name in the name conflict dialog box."

This appears 4 times with the names Foodcourt, Rates-taxes, sinkfund & wrn.full being the names it claims exist. I want to get rid of these prompts appearing but the trouble is I have searched everywhere in the spreadsheet for any of those 4 names and cannot find a thing. Any ideas where I should be looking?

Many thanks,

 

[pgc01]

Hi skaxamax
Welcome to the board

Maybe...

In xl 2007 check in Formulas>Name Manager, in previous versions in Insert>Name>Define

 

[skaxamax]

Wow, page 2 already. Busy board.

Thanks pgc, I checked that but none of those names are there (using 2003). Another guy I know who used this sheet is also quite good at excel and when I asked him about this he said it drove him nuts and he could not figure it out either. The "wrn.full" name seems to be particularly weird.

 

[pgc01]

Have you checked if the names are invisible?

Run this code. It will display any invisible names you may have:

Sub DispayInvisibleNames()
Dim nm As Name
 
    For Each nm In Names
        If nm.Visible = False Then MsgBox nm.Name
    Next nm
End Sub

 

[pgc01]

P. S. You have to run the code from a general module, not from a sheet module.

 

[skaxamax]

Thanks pgc, I think you're onto something.

When I ran it the unknown names I have appeared in a message box. It seem to run through the entire worksheet but once completed I thought I would see these names in the "define name" list? Do I have to now make them visible somehow?

Thanks,

 

[skaxamax]

After some searching I found a name manager program. Appears I have invisible name ranges that refer to nothing.

Thanks for your help.