Errors when copying sheets

[Keith]

I have a macro that copies a sheet and renames it.
However, when it is copying, I get the following error:

A formula or sheet you want to move or copy contains the
name '\a' which already exists on the destination
worksheet.

I also get another one with a different name.

I cannot find this named ranged or anything that is
associated with it. I am using Excel 2002 and have
Hyperion Essbase installed.

Thanks in advance,

Keith

 

[Dave Peterson]

I think that Lotus used that naming convention for its macros. (But it might
have been the slash instead of the backslash.)

Jan Karel Pieterse, Charles Williams and Matthew Henson created a utility to
work with names.

You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp

Maybe you can use that to delete the name (assuming you don't need it). Or just
use it to find out what it refers to.