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]

It might be better if you could post the spreadsheet here or on the internet where someone could look at it. The circumstances of when it happens might also be useful. One thing that might cause a problem is if it is run while the sheet that it was made for is not active or something along those lines.
Since it works most of the time it might not be a problem with the code, but some other circumstances.

 

[bobaroski2121]

I could post the spreadsheet, but I was wondering if someone knew what the error specifically meant. When looking online, i was unable to find what part of the macro the error refers to other than the generic sort function. It happens when I am adding a new entry to the spreadsheet, i.e. one column is 'date', the next is 'entry type', the next 'details'. After typing in the date, the error will appear. I will start uploading the spreadsheet now

 

[bobaroski2121]

here is the link for the spreadsheet to download. it will need to be shared via google drive

https://drive.google.com/a/rgsskb.net/file/d/0B8wOL2OK3zWyV2lTYml3Q1hLWEE/edit?usp=sharing

 

[skywriter]

It says I need permission to access it. I clicked the appropriate button you should be getting a request from google to let me access it.

 

[bobaroski2121]

just changed the permission settings. the tab in question is 'Remington Park (Quarter Horse)'. I am trying to add the date for the newest entries at the bottom

 

[skywriter]

I downloaded your sheet and ran the macro and got the error. It appears the sheet is protected, which might be the problem. I obviously don't have your password, but you might see if it is a simple as this. I know I have run into similar problems and they were caused by the sheet being protected.

 

[bobaroski2121]

I tried that but the thing that seems odd is that the other sheets are protected (theyre all protected with the same macro) and yet I dont seem to get the error

 

[skywriter]

Check what is protected on the sheet. I just looked at another spreadsheet I have and one of the protection options is sort. Make sure that option is checked for that sheet. When I right click that cell on that sheet sort is grayed out, but on another sheet as you say sort is not grayed out and therefore leads me to believe this is your problem. At least unlock the sheet and try it that way and check the protection options that are selected for that sheet.

 

[bobaroski2121]

That did it. It seems when I put together the protect all macro, something (or someone in the office) also placed a protect sheet for that specific sheet. I had the same issue on two other sheets and that solved it. Thanks for your help!!!