mf1
Member
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
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