Unreadable content / removed sorting - macro help

Hi all,

I get an error when I try to open a .xlsm file after a macro ran in a previous editing session of that file. The error is that Excel found unreadable content and when I choose repair the following message is displayed: "Removed Records: Sorting from /xl/worksheets/sheet3.xml part". When I repair the file without running the macro and save and reopen the file, there is no error message.

The macro that does a A-Z sorting on the 3rd sheet (named "Inventory") is copied below. I googled for a solution and the only thing I could find was to insert: ActiveWorkbook.Worksheets("Inventory").Sort.SortFields.Clear after the End With. I did that but this didn't solve the issue. Maybe I copied it in the wrong place or my code is just bad (I'm new at this...). Hope someone can help me! Thanks a lot!

Please Login or Register  to view this content.

Hi,

Perhaps this instead

Please Login or Register  to view this content.

Is the data on that sheet in a Table?