Results 1 to 2 of 2
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Intermitant Error (Excel VBA)

    Afternoon All,

    I have a VBA macro that copies a template sheet. Every now and then I get an error ... "copy method of worksheet failed". The actual code is ...

    <pre>Sheets("$TEMPLATE.fac").Copy after:=Sheets(lsPrevSheetName)
    </pre>


    where lsPrevSheetName is a valid value.

    sometimes it works, sometimes is stops working half way through. I usually have to exit excel and restart it but sometimes I need to reboot.

    Any takers on what is going wrong?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intermitant Error (Excel VBA)

    How silly is this. There is a knowledge base article that discusses this issue and suggests a work around - basically close the workbook (saving changes) and then re-open it. It looks like MS are extending the concept of 'fix all problems with a reboot'.

    The knowledge base article is here ...

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q210/6/84.ASP>http://support.microsoft.com/support/kb/ar...s/Q210/6/84.ASP</A>
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

Posting Permissions

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