Thread: Rogue name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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