Why would I receive this repairs sorting message?

[mf1]

Hello,

I randomly have this repair message appearing (attached) when I open my spreadsheet. I think it refers to the sort macro I have, see below an example of the sort criteria;

ActiveWorkbook.Worksheets("Whiteboard_PDF").Sort.SortFields.Add Key:=Range( _
"E5:E29"), SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:= _
"9 - 11,9 - 1,9 - 3.30,9 - 5,10 - 11,10 - 11.30,10 - 12,10 - 12.30,10 - 2,11 - 1,11 - 1.30,11 - 3,12 - 2,12 - 2.30,12 - 4,1 - 3,1 - 5,2 - 4,2 - 4.30,2 - 6,3 - 5,3 - 7,3.30 - 5.30,4 - 6,4 - 8,4.30 - 8.30,5 - 7,5 - 9,5.30 - 7.30,5.30 - 8,5.30 - 9.30,6 - 8,6 - 10,7 - 9" _
, DataOption:=xlSortNormal

Is there a limit on how many numbers that can be sorted, as this sort has had times added over the past week?

I select repair and save as a new file, then the error/repair will randomly appear 1 or 2 days later?

Cheers,

mf1

 

[Luke M]

There is a limit of 256 characters in a custom list, so yes, that is what is causing the problem.
I would suggest creating a lookup table showing your list, and then the numbers 1-N. Have a helper column lookup the sort number, and then sort on that helper column.

 

[mf1]

Thanks Luke