View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Errors when copying a sheet

Names can be hidden.

\a looks like the way one used to mark lotus 1-2-3 macros which were
entered in a worksheet.

Regards,
Tom Ogilvy


"Dan E" wrote in message
...
Keith,

How did you look for the named range?
Try "Insert" - "Name" - "Define"
It should have a list of all the named ranges.

Dan E

"Keith" wrote in message

...
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