Excel has stopped working... after custom sort

Just an FYI for others that may run into this problem. I found several others had posted the problem to various forums. I tried the various proposed fixes and none worked for my particular case.

Anyway, my macro creates a custom sort list, sorts a range, then deletes the custom list. Excel 2010 would crash upon attempting to save the file after running the macro. I finally narrowed the cause to this line of code:

Please Login or Register  to view this content.

The best method I could come up with to prevent the crashing was to add the following lines:

Please Login or Register  to view this content.

...where A1:A2 is an empty range.

I'm open to a better method to prevent the crashing, but short of a better method, the above worked for me.

Originally Posted by shg

Please Login or Register  to view this content.

Originally Posted by jhren

Okay... I'll try it later (preoccupied with something else right now) and report back at that time.

...

Tried and confirmed it works...

Thanks.

Thanks
This worked for me to.

I got the following error in event viewer:

Faulting application name: EXCEL.EXE, version: 14.0.7104.5000, time stamp: 0x51cdffef
Faulting module name: MSVCR90.dll, version: 9.0.30729.6161, time stamp: 0x4dace5b9
Exception code: 0xc0000417
Fault offset: 0x000320f0
Faulting process id: 0x17a4
Faulting application start time: 0x01cf79aaf1e1880a
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Faulting module path: C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll
Report Id: 3c54bee8-e59e-11e3-b65e-f01faf3f25bb