Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: error message when copying a sheet in a workbook

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This problem has stumped me for over a year...

    I get an error message when I try to copy
    one of my worksheets within a workbook.

    "A formula or sheet you want to move or copy
    contains the name 'FEB98_AP', which already exists on the destination worksheet. Do you want to use this version of the name?
    . To use the names 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."

    I have no idea where this name is orginating
    from, and when I try a "Go To" command, nothing comes up. I tried to paste a Name list, and nothing. I cannot find this referent!! Please help as it has me stumped.

    How could it already exist on the destination worksheet as I am using the "copy worksheet" function, and this message appears after I tell it to "move to end"??



  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you currently have now or in the past
    named ranges such as this ??

    If you have/haven't then you can delete them
    since they may be hidden vai a macro

    Post if interested
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ivan,

    Thank you kindly for this reply. I have been stumped for a long time.

    I do not have these name ranges.

    If these range names are hidden in a Macro,
    How would I find them?

    When you do the Name Range Paste List, nothing comes up.

    I have deleted all rows and columns outside of the area of the spreadsheet that I use.
    The error message still comes up when I try to copy the sheet.

    Thanks again for the input.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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