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>
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>
