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