ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Rogue name (https://www.excelbanter.com/excel-programming/384107-re-rogue-name.html)

Tom Ogilvy

Rogue name
 
Names may be hidden. You could run code like this

Sub shownames()
Dim nm as Name
for each nm in Activeworkbook.names
nm.Visible = True
Next
End Sub

then look in Insert=name=Define to see what names are there.

--
Regards,
Tom Ogilvy


"Gizmo63" wrote:

Hi all,

Has anyone come across this before?

One of my programs copy pages between a template workbook into a live
workbook and I get the message that:
"a formula or sheet you want to move or copy contains the name
'wrn.amanda._.version.' which already exists on the destination worksheet."

I cannot find this name anywhere to remove it, it doesn't appear to do
anything either.

Baffling and irritating! Can anyone help?

Cheers

Giz



All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com