name existing on the destination folder

**LeFootie** · 07-03-2012, 02:09 PM

Dear friends

I am trying to copy a sheet from one workbook to another through macro.

For some reason i get this message:

Capture.PNG

Im not sure what Excel means by "name A"in this case. I dont know where to change this variable. Any ideas where I can adjust "names".

Thanks a lot!

**Oppressed1** · 07-03-2012, 02:45 PM

My virus software prohibited me from opening the attachment. Is there another way to display images in messages here? (Failing that, maybe give a flickr or photobucket link that I won't mind opening)

**LeFootie** · 07-04-2012, 03:32 AM

The message is like this:

" A formula or sheet you want to move or copy contains the name ''A'', which already exists on the destination worksheet. Do you want to use this version of the name?
- To use the name as defined in the destination sheet, click Yes.
- To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box "

**Oppressed1** · 07-05-2012, 11:09 AM

In nearly all instances I click Yes. Type Control-F3 on each workbook to see range names, of which I predict you'll see that "A" is defined in both of them.

Normally you want to avoid linking the 2 workbooks, and if you have accidentally done so (in Excel 2003 and earlier, menu Edit/Links shows links rather than is gray), I normally delete the linked range so that the moved or copied sheet in the destination workbook refers to range A in the destination workbook, rather than the source workbook.

Many recommend the product "name manager" at http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp to help understanding and managing ranges and links. I understand that XL2007+ have a "name manager" built in, so investigate that first.

Edit: Note that if you type
"formula or sheet you want to move or copy contains the name"
in the search box above you get more information. Consider Google similarly.