Macro Runs OK Then Excel Crashes on Save

Lasharena

New Member
Joined
Apr 17, 2013
Messages
4
Hello All, I started my first VBA project for work and am now at my wits end with this (hopefully) last problem.

My macro runs absolutely fine, but after it is done running when I try to save/save-as the file containing the macro it crashes all of Excel. I am given the below error details before it completely closes Excel, unsaved.

I have tried copying from my project file to a clean file with the same problem. When I step through the entire macro, or set periodic stopping points, it WILL let me save. But EVERY time I run all the way through it crashes. Thus I cannot even pinpoint what section of code may be causing this.

I've searched many threads that either have 1) no solution given or 2) a solution that is not applicable to the code I have in my own macro.

Problem signature:</SPAN>
Problem Event Name: APPCRASH
</SPAN>
Application Name: EXCEL.EXE
</SPAN>
Application Version: 12.0.6665.5003
</SPAN>
Application Timestamp: 5061d2a8
</SPAN>
Fault Module Name: EXCEL.EXE
</SPAN>
Fault Module Version: 12.0.6665.5003
</SPAN>
Fault Module Timestamp: 5061d2a8
</SPAN>
Exception Code: c0000005
</SPAN>
Exception Offset: 004863b3
</SPAN>
OS Version: 6.1.7601.2.1.0.256.48
</SPAN>
Locale ID: 1033
</SPAN>

Additional information about the problem:
</SPAN>
LCID: 1033
</SPAN>
Brand: Office12Crash
</SPAN>
skulcid: 1033

Thanks in advance for your help! I've gotten some amazing help just browsing other people's posts :)
</SPAN></SPAN>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,216,124
Messages
6,128,993
Members
449,480
Latest member
yesitisasport

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top