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
|