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

Rogue name
 

Thanks for the idea Tom, but no go.

Still not visible anywhere.

Giz

"Tom Ogilvy" wrote:

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

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

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

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