Excel 2007 : Sorting - Message re Removed Records

perrush, welcome to the Forum. As a new member, please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member.

We also have a rule against hijacking, which is asking a new question in an existing thread. In this case I'll give you the benefit of the doubt since your question is directly related to advice given here. You must put your line of code

ActiveWorkbook.Worksheets("LTSB").Sort.SortFields.Clear

at the beginning, not the end.