Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rogue name
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rogue name
I'd try Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rogue name
You know; I'd forgotten all about that facility!
I have it as part of FastExcel but, darn it, it still doesn't show that name!! Giz "Dave Peterson" wrote: I'd try Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rogue name
The wrn.* in 'wrn.amanda._.version' very likely means it's a hidden system
name. Have you ticked "Show Excel System names" in NameManager Look on both source & destination sheets. Regards, Peter T "Gizmo63" wrote in message ... You know; I'd forgotten all about that facility! I have it as part of FastExcel but, darn it, it still doesn't show that name!! Giz "Dave Peterson" wrote: I'd try Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rogue Link | Excel Discussion (Misc queries) | |||
Rogue name | Excel Programming | |||
Rogue Admins | Excel Programming | |||
rogue links appear in excel | Excel Worksheet Functions | |||
Rogue vertical pagebreak | Excel Programming |