The custom sort list causes my excel to crash after running and then trying to save

Hi all,

I have the following custom sort code that I am using to sort column A on the exposure tab. I saw someone else online with a similar request of my own and modified the code online to my personal needs. The sort code works exactly like I would expect it to, but after running the macro for the code below and subsequently trying to save the workbook the workbook crashes and excel is unable to recover the file. No matter what I do it will not allow me to save my workbook after using the below code. Would anyone have any suggestions on how I could clean up the code and/or use an alternate method so I would not have the crashing issue?

Thanks,

Jon

Please Login or Register  to view this content.

Try adding the save command at the end of your sub.

Please Login or Register  to view this content.

I'm having the same problem - it only seems to happen when a custom sort order is involved - it happens whether I use the range.sort method or sortField.add. The save command at the end of the sub only automates the crashing.

Ok - it turns out that deleting the custom list was the source of my problem (whether with VBA or manually) and clearing the sortFields (ActiveSheet.Sort.SortFields.Clear) right before calling the DeleteCustomList method fixed this for me.

Originally Posted by stuartho

Ok - it turns out that deleting the custom list was the source of my problem (whether with VBA or manually) and clearing the sortFields (ActiveSheet.Sort.SortFields.Clear) right before calling the DeleteCustomList method fixed this for me.

Thanks for the Tip!

This answer is over 10 years old and it is gold!!! I have been having this issue for 3 days now and managed to narrow it down to one line of code. NOWHERE on the internet is this explicitly defined to add the .clear line in the script. Many many thanks.