Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rogue Link | Excel Discussion (Misc queries) | |||
Rogue Admins | Excel Programming | |||
Rogue Password on Properties and References | Excel Discussion (Misc queries) | |||
rogue links appear in excel | Excel Worksheet Functions | |||
Rogue vertical pagebreak | Excel Programming |