Hey guys,
I've got a macro in one of my documents what sorts all the cells by the time (format of: 15:55 for example) and it keeps creating unreadable content, so whenever I re-open my document it recovers it does the following "Removed Records: Sorting from /xl/worksheets/sheet4.xml part"
Could anyone help me fix it to stop this issue from happening?
Sheets("QC").Sort.SortFields.Add Key:=Range("T2:T" & CLastRow), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With Sheets("QC").Sort
.SetRange Range("A2:T" & CLastRow)
.Orientation = xlTopToBottom
.Apply
End With
Thanks in advance.
- Hyflex
Bookmarks