Mystery Crashing of Excel After Saving Code

[Ark68]

After I edit a module in Microsoft Visual Basic for Applications, I routinely save the code. But within a few seconds of saving, Excel crashes, restarts, and opens the last saved version of the document that was being worked on at the time of the crash. Is there a means of checking what might be causing this crash? The code isn't (shouldn't be) running to be the culprit. It only happens after I run my code and it programmably stops in this module to allow me to step though, edit and save changes.

 

[Logit]

Well ... I admit that someone more knowledgeable than me will need to assist here.

Sorry. Trust you will quickly find a solution to your dilemma.

I'll follow this thread for a solution.

Best wishes.

 

[Ark68]

I do appreciate the effort!!

 

[Ark68]

To anyone still hopefully following this ...
If I delete this line of code from the module, I lose the Excel crash experience.

        'Application.DeleteCustomList Application.CustomListCount

 

[Logit]

.
Just found this ... hopefully ???

Thank you for figuring out the reason for this BUG, clearing the Sortfields fixes that issue.

Using DeleteCustomList in a VBA macro causes excel 2010 to crash

 

[Ark68]

Ding ding ding ding!!! Winner winner chicken dinner! That indeed was the golden ticket Logit. Your persistence paid off and for that I extend my gratitude.

 

[Logit]

Hurray !!!!!

Glad you have an answer.