Auto Sort Macro Error, Office 365

[bobaroski2121]

I have an auto sort macro that arranges entries based on the date placed in the column.

Sub Sort_Macro()
Range("A25:O2000").Sort Key1:=Range("A26"), Order1:=xlDescending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
End Sub

It seems random, but occasionally I will receive an error:

Run-time error 1004: Sort method of Range class failed.

I cant seem to figure out hwo to debug. any thoughts?

 

[skywriter]

My pleasure.