+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 keeps crashing when running a specific macro.

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    22

    Excel 2010 keeps crashing when running a specific macro.

    Please can someone help, I have gone through numerous websites trying to find an answer to this problem.

    I have a workbook that contains many different macros that are all working well. But I have one worksheet that is causing me a great deal of issues. Basically all it is doing is selecting data, copying and pasting to another worksheet. The macro does what it is supoosed to do but when it exits the su, excel crashes, I get no de-bug or help on the problem from excel.
    So that all my data does get lost after the crash I have included a save as so at least when I opened it back up all the moved data is where it should be.
    To try and de-bug this problem I have disbaled parts of the code to see if there is a particular section of code causing the problem, but no I have found nothing. I have ended up disabling all the code apart from the save as and the double click that activates the macro and excel still crashes. I have similar code to this in other parts of the workbook and it seems to work fine. I am very confused can anyone help or suggest anything I can try?

    Thanks for looking

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Excel 2010 keeps crashing when running a specific macro.

    Hi -

    Nobody can guess either. posting your file would be better.

    event

  3. #3
    Registered User
    Join Date
    10-19-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Excel 2010 keeps crashing when running a specific macro.

    Hi event21,

    I didn't want to post my entire workbook so I have managed to pull out the worksheet and code and placed mock data in and it still seems to crash. Just before I posted this I checked on two other computers to see if I still had the same problem and it all works fine. This is now leading me to believe it could be a problem with my laptop. I will let you know if I find the problem I was wondering if it could be a Addin?

    Thanks

+ 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