Errors when tab copying

[Reese]

I have a worksheet that when I try to copy a tab I keep
getting 3 error messages that says "A formula sheet you
want to move/copy contains the name "", which already
exists on the destination worksheet. Do you want to use
this version of the name?" If I click yes, I get 3 more
of the same message with different doc names. If
clicking no I get a box that says name conflict, name
exists on destination sheet. Then it lists the old name:
& asks for a new name. If I enter a new name, nothing
happens. HELP!!!

 

[Tushar Mehta]

What kind of help would you like?

As XL indicates you have the same name in the source and destination
workbook and XL doesn't know how to resolve the conflict. To see more
about what names you have use Insert | Name > Define... or check out
the Name Manager add-in at
http://www.bmsltd.ie/MVP/MVPPage.asp#JanKarelPieterse

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions