error message when copying a sheet in a workbook
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.



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
  •  

 

 
DMCA.com