Excel Crashes when trying to save after running a sort macro

I have attached the workbook. there are 5 sheets. all the sheets have text boxes that when clicked run a macro. the textbox labeled Sort runs the CustomSort macro. when i run the sort macro in sheet 2 named Blank with part (2 Columns) it saves fine.

But if i run that same macro on sheet 4 named Blank With Part (4 Columns) it will run the sort macro but after that i try to save it and it crashes. it does not crash when i run any of the other macros so i have narrowed it down to the customsort macro.

I just dont understand why it would work on one sheet and then not the other.

this is driving me crazyyyy

any help would be awesome

i have already tried clearing my temp files and that did not help


thanks
JD

change the antepenultimate line of your code to refer to sheet instead of 'Blank with part (2 columns)' when clearing the sort fields

sheet.Sort.SortFields.Clear