Untraceable Name in Excel 1

[ajcarr]

I have a worksheet which when I try to copy it, comes up with the message
"A formula or sheet you want to move or copy contains the name wrn.WARRANTY._.REPORT which already exists on the destination worksheet"

However, I cannot find this name anywhere in the worksheet. There is no name like that in the names list and Find does not identify it either. The only name like that I used was many years ago and it looks as though it may be some sort of hangover from an old workbook - but how do I get rid of it?

 

[Paul666]

Have you tried just copying/pasting the contents of the sheet?

 

[ajcarr]

Paul, I've tried this and the name comes across with it. I've tried selecting all cells, just the rows and columns which contain data but whichever method I try the name still keeps re-appearing. It has got into a number of workbooks (I tend to use one book as a template for another). The reference to it only appears when copying a worksheet - no other time.

I wondered if the wrn. prefixindicated anything. The last workbook I had which referenced Warranty reports was back in Excel 4.0 days so I'm wondereing if it is some long lost feature from then.

Regards,
Allan

 

[KenWright]

Have you tried Bill Manville's superb free addin called Findlink.

http://www.bmsltd.co.uk/MVP/Default.htm

or even Jan Karel Pieterse's free NameManager addin, available from the same link (just click on his name on the left - Bill's addin is the first one on the page)

Both should find it for you.

Regards
Ken..............

 

[cheerio]

Anything from those two guys is good. In fact the whole site has some great stuff I have used for years.

 

[combo]

Names can be hidden, i.e. non-visible in the "names" box.
So, maybe this code will help to find it:
ThisWorkbook.Names("wrn.WARRANTY._.REPORT&quot.Visible=True
or
MsgBox Names("wrn.WARRANTY._.REPORT&quot.RefersTo

If it is a name used in a formula, select all cells and try with Edit>Find

combo

 

[ajcarr]

Ken/Combo. Thanks for your help. The Bill Manville XLA failed to find the name but the Jan Karel Pieterse's one did the trick. I used Combo's code and it executed the ".Visible=true" OK but didn't show anything in the Names list. The "RefersTo" listed the same cell contents as Jan's XLA. It was obviously a range of data, mostly #N/A but with a few other recognisable text fields. However, none of these could be found by Find. Very strange indeed. Anyway, all fixed now thanks to your help.

The bmsltd site really does contain some useful stuff - I downloaded a couple of other useful utilities while I was there. Thanks for pointing me to it.

Regards,
Allan