Microsoft Excel has stopped working

[Pinaceous]

Hello Everyone,

After running a sub that transfers information to another workbook, I occasionally get this error message generating that:

Microsoft Excel has stopped working Windows can try to recover your information. -> Close the program

Is there a way that I can clear this message out in a similar way that:

 Application.CutCopyMode = False 'Clear Clipboard

Clears the Clipboard?


Thanks,
Pinaceous

 

[gruntingmonkey]

I don't think there is. Essentially Excel has corrupted and therefore needs to restart. Does it happen once in a blue moon or is it happening to a particular workbook?