+ Reply to Thread
Results 1 to 19 of 19

Move/Copy Sheet Message

  1. #1
    Registered User
    Join Date
    08-29-2006
    Posts
    62

    Arrow Move/Copy Sheet Message

    In an Excel workbook I use that has several sheets, when I copy/paste/create a sheet into the same workbook twice, I get a message box that reads:

    A formula or sheet you want to move or copy contains the name '----' 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 dialogue box.

    I have to click YES 26 times to get through all the names that pop up.

    I have no idea what this is all about. I have used EDIT/Find to try to locate the name in both text and formulas, but they are not found. They are not macros either.

    Has anyone else seen this message? Can you direct me to find where the conflict is?

    Any help would be appreciated.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    It's a name range. The attached shows you were to look for them

    http://www.homeandlearn.co.uk/ME/mes9p2.html

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi again,

    This link has a addin to help manage Name ranges

    http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

    VBA Noob

  4. #4
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I looked in INSERT/Name/Define, and non of the names that pop up in the message box are there. Is there another way to find them?

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Do you check the orginal workbook

    VBA Noob

  6. #6
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I am copying and pasting into the same workbook.

  7. #7
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Argh,

    I think you might be trying to rename a sheet that already exists.


    VBA Noob

  8. #8
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I am copying and pasting into the same workbook. This is something I do all the time, Excel just renames the Sheet with a (2), or (3), etc. For example if I copy/paste/create the Sheet "Analyzer" into the same workbook I would get a sheet named "Analyzer (2)" If I need a third (or fourth or fifth, ect.) sheet named "Analyzer", do a copy/paste/create, I get the message box previously described. I have to click YES 25 or 26 times to get the sheet to copy each time. If these are named ranges shouldn't EDIT/Find locate the names?

  9. #9
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    For name's

    Go to insert > Name > Define

    VBA Noob

  10. #10
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I did that and none of the names in the message box appear in the Define Box.

  11. #11
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Upload the file and I'll take a look

    VBA Noob

  12. #12
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    This is a workbook that has confidential information in it so I had to move the sheet that is giving us problems to a new workbook, and empty all the cells in it. The error still occurs. Any help would be appriciated.

    Thank you


    I tried to upload the file, but am not sure it worked. If it is not attached, please let me know.

  13. #13
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No attachement



    VBA Noob

  14. #14
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No attachement



    VBA Noob

  15. #15
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No attachement



    VBA Noob

  16. #16
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I am not sure how to attach a file from Excel. Is there an email address I could send the file to?

  17. #17
    Registered User
    Join Date
    12-08-2004
    Posts
    19
    Mary Frances-
    I have had this happen as well.

    The previous posts were going in the right direction, but you just need to try one more step.

    Go to Insert/Name/Define, but you need to do this on each tab of the workbook. I don't know exactly why, but Excel doesn't show the names for each worksheet unless you are on that specific worksheet sometimes. This only seems to happen for me when I copy/paste workbooks.

    It could also be in the background under the hidden VBA.

    If that doesn't work, let us know. To submit an attachement, at your post, click on the paperclip at the top and then browse for the file and then upload it (you will need to zip it first).

  18. #18
    Registered User
    Join Date
    08-29-2006
    Posts
    62
    I did an EDIT/Find in Visual Basic and did not find the names I am looking for.

    I think I have the file attached now.

    Thanks.
    Attached Files Attached Files

  19. #19
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Below are all your named ranges in this workbook. I assume your not using them. I would deleted them.

    This site as a free addin

    http://www.bmsltd.co.uk/mvp/

    to download click here

    http://www.bmsltd.co.uk/DLCount/DLCo...ameManager.zip


    Analyzer (6)'!abc ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!abc ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!abc ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    abc ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (6)'!abd ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!abd ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!abd ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    abd ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (6)'!adf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!adf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!adf ={"Über",#N/A,FALSE,"ABL 505"}
    adf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!adg ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!adg ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!adg ={"Über",#N/A,FALSE,"ABL 505"}
    adg ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!adgf ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (7)'!adgf ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (8)'!adgf ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    adgf ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (6)'!adgg ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (7)'!adgg ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (8)'!adgg ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    adgg ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Annual_interest_rate ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$C$15
    API_Call_GetPrivateProfileString ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$56
    API_Call_Play_WAV_File ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$63
    Analyzer (6)'!asdf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!asdf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!asdf ={"Über",#N/A,FALSE,"ABL 505"}
    asdf ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!asdg ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!asdg ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!asdg ={"Über",#N/A,FALSE,"ABL 505"}
    asdg ={"Über",#N/A,FALSE,"ABL 505"}
    Branch_Example ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$22
    Code ='C:\DOCUME~1\mrut\LOCALS~1\Temp\[DocChanges.xls]#REF'!$A$3:$A$29
    Description ='C:\DOCUME~1\mrut\LOCALS~1\Temp\[DocChanges.xls]#REF'!$B$3:$B$29
    Analyzer (6)'!det_5 ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (7)'!det_5 ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (8)'!det_5 ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    det_5 ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (6)'!dfg ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!dfg ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!dfg ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    dfg ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (6)'!dfh ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!dfh ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!dfh ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    dfh ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Distance ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$9
    Euro ='C:\DOCUME~1\mrut\LOCALS~1\Temp\[DocChanges.xls]#REF'!$D$3:$D$29
    First_payment_due ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$C$18
    For_Next_Loop ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$24
    HospitalName =#REF!$B$157:$B$8644
    Main_Procedure ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$49
    Move_Active_Cell_Using_Variables ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$14
    MS_Query_Fetch ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$30
    Neteuro ='C:\DOCUME~1\mrut\LOCALS~1\Temp\[DocChanges.xls]#REF'!$E$3:$E$29
    Payments_per_year ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$C$17
    Pmt_to_use ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$C$23
    Analyzer (6)'!Print_Area ='Analyzer (6)'!$A$1:$L$76
    Analyzer (7)'!Print_Area ='Analyzer (7)'!$A$1:$L$76
    Analyzer (8)'!Print_Area ='Analyzer (8)'!$A$1:$L$76
    Analyzer (6)'!sadf ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (7)'!sadf ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (8)'!sadf ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    sadf ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (6)'!sadg ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (7)'!sadg ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (8)'!sadg ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    sadg ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (6)'!sdf ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!sdf ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!sdf ={"Det",#N/A,FALSE,"ABL 505"}
    sdf ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!sdg ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!sdg ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!sdg ={"Det",#N/A,FALSE,"ABL 505"}
    sdg ={"Det",#N/A,FALSE,"ABL 505"}
    Select_Top_to_Bottom_Left_to_Right ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$31
    Sort_Database_Without_Headers ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$6
    Subroutine ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$58
    Term_in_years ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$C$16
    Test_For_Multiple_Conditions ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$6
    USD ='C:\DOCUME~1\mrut\LOCALS~1\Temp\[DocChanges.xls]#REF'!$C$3:$C$29
    Using_Variables_With_Offset ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$22
    While_Next_Loop ='C:\DOCUME~1\mrut\LOCALS~1\Temp\Documents and Settings\mrut\My Documents\Quotes\[MR1001-R5 Lake Charles Mem-Lake Charles, LA.xls]#REF'!$A$37
    Analyzer (6)'!wrn.Det_5. ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (7)'!wrn.Det_5. ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (8)'!wrn.Det_5. ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    wrn.Det_5. ={"Det",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (6)'!wrn.Det_505. ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!wrn.Det_505. ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!wrn.Det_505. ={"Det",#N/A,FALSE,"ABL 505"}
    wrn.Det_505. ={"Det",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!wrn.Det_5XX. ={"Det",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (7)'!wrn.Det_5XX. ={"Det",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (8)'!wrn.Det_5XX. ={"Det",#N/A,FALSE,"ABL50-500-510-520"}
    wrn.Det_5XX. ={"Det",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (6)'!wrn.Det_EML. ={"Det",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (7)'!wrn.Det_EML. ={"Det",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (8)'!wrn.Det_EML. ={"Det",#N/A,FALSE,"EML Stand-Alone"}
    wrn.Det_EML. ={"Det",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (6)'!wrn.Det_SYSTEM. ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!wrn.Det_SYSTEM. ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!wrn.Det_SYSTEM. ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    wrn.Det_SYSTEM. ={"Det",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (6)'!wrn.Über_5. ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (7)'!wrn.Über_5. ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (8)'!wrn.Über_5. ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    wrn.Über_5. ={"Über",#N/A,FALSE,"ABL5 - BPH5"}
    Analyzer (6)'!wrn.Über_505 ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!wrn.Über_505 ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!wrn.Über_505 ={"Über",#N/A,FALSE,"ABL 505"}
    wrn.Über_505 ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!wrn.Über_505. ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (7)'!wrn.Über_505. ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (8)'!wrn.Über_505. ={"Über",#N/A,FALSE,"ABL 505"}
    wrn.Über_505. ={"Über",#N/A,FALSE,"ABL 505"}
    Analyzer (6)'!wrn.Über_5XX. ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (7)'!wrn.Über_5XX. ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (8)'!wrn.Über_5XX. ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    wrn.Über_5XX. ={"Über",#N/A,FALSE,"ABL50-500-510-520"}
    Analyzer (6)'!wrn.Über_EML. ={"Über",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (7)'!wrn.Über_EML. ={"Über",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (8)'!wrn.Über_EML. ={"Über",#N/A,FALSE,"EML Stand-Alone"}
    wrn.Über_EML. ={"Über",#N/A,FALSE,"EML Stand-Alone"}
    Analyzer (6)'!wrn.Über_SYSTEM. ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (7)'!wrn.Über_SYSTEM. ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    Analyzer (8)'!wrn.Über_SYSTEM. ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    wrn.Über_SYSTEM. ={"Über",#N/A,FALSE,"ABL SYSTEM"}
    VBA Noob

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1