![]() |
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