My Macro has developed an error on start up - not file corruption

[TheRedCardinal]

The last couple of days the script that I am working on has developed an error when the workbook is loading.

Windows post a message saying

"We found a problem with some content in [My Workbook] - Do you want us to try to recover as much as we can."

When I click yes, the file opens and there is a report window which says:

"Removed Records: sorting from /xl/worksheets/sheet8.xml part"

There is one part of my macro which sorts a worksheet, but it is not sheet8.
Now sheet 8 is a hidden sheet which contains some data for the workbook.

This happened yesterday so I restarted my project afresh with new source documents and it has happened again.

Does anybody know what causes this error?

 

[MARK858]

Try running

Sheet8.Sort.SortFields.Clear

and see if it clears the issue (please note that I am using the sheets codename)

 

[TheRedCardinal]

Try running

Sheet8.Sort.SortFields.Clear

and see if it clears the issue (please note that I am using the sheets codename)

I actually did this anyway and it seems to have cleared the error - I did it within a "With WS1" block that the sort fields were part of (not sheet 8!). But it still worked.

I'm a little confused as to what's going on!

 

[Fluff]

Firstly sheet8.xml is the 8th sheet in the workbook, counting from left to right including hidden sheets
Secondly when using the SortFields.Add method of sorting, if you do not delete the existing sort, it just keeps adding new sort fields until there are too many & you then get problem you encountered.
So as Mark pointed out, you need to delete the existing sortfields, before adding any more.