All my macros are receiving Automation error when performing sort functions

[clovely]

Today when I when I run macros that worked fine yesterday(and several months before) they throw this error when they hit a sort operation:

Here is a sample of the code that is errors. The orange code is highlighted yellow in the VBA editor when I debug:

vEnd = Range("B65536").End(xlUp).Row
ActiveWorkbook.Worksheets("Backlog").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Backlog").Sort.SortFields.Add Key:=Range( _
"C4:C" & vEnd), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortTextAsNumbers

Any previously fine macro that has a sort operation is throwing this error. Also if I record a new macro and sort a file then try to rerun that macro I will get the same error. I tried doing a repair on my Office and still get the error. I am currently stuck and not sure what to try to fix this.

This is on a Windows 10 PC running Office 365.

 

[clovely]

Our local IT guy had me delete the Excel folder in the registry and that seems to have fixed my issue:

I will continue using Excel for the day and see if this issue is truly resolved and update this post.

 

[clovely]

The deletion of the Excel file in the registry has fixed my issues. I will note that this set all the options to default, but did not remove my custom ribbon or my personal macros.

Thanks everyone for your assistance. Several good ideas were given and tried.