Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    move/copy worksheet (Excel 2002 SP3)

    I have an issue that has just popped up in the last couple of days. I have tried to move/copy a worksheet from one workbook to another, and get the error shown below. This has happened to me both when right clicking the worksheet name and selecting move/copy worksheet and when I tried to copy a worksheet using VBA code. The code that I am using had worked fine for over a year until earlier this week.

    Any ideas, as it is very frustrating to not be able to copy a worksheet.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: move/copy worksheet (Excel 2002 SP3)

    That may be corruption in the workbook. Try saving the workbook in HTML format. Close Excel. Open Excel and open the HTML file. Save the file back in .xls format. Keep a copy of the original file as this may result in the loss of some formatting.
    Legare Coleman

Posting Permissions

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