Macros do not work on a PC but do on other ones

Hi all,

Here is the code with 6 alternatives to execute a simple ".Sort.SortFields.Clear" command.

None of them work on my PC but they all do on other computers. All alternatives on my PC show the

"run-time error '9': subscript out of range". Please note that I get the same error with the "AutoFilter" command.

This thread has also been posted on the Microsoft community website.

Thanks very much, Alan.

Sub test_autosort()
ActiveWorkbook.Worksheets("Sheet1").AutoFilterMode = False
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual


' 1st alternative
' Rows("6:800").Select
' Worksheets("Sheet1").Sort.SortFields.Clear

' 2nd alternative
' With ActiveSheet
' .Sort.SortFields.Clear
' End With

' 3rd alternative
' With Worksheets("Sheet1")
' .Sort.SortFields.Clear
' End With

' 4th alternative
' With Worksheets(1)
' .Sort.SortFields.Clear
' End With
'
'5th alternative
'ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear


'6th alternative
With ActiveWorkbook
Worksheets(1).Sort.SortFields.Clear
End With

End Sub

.Sort.Sortfields.Clear.PNG

Hi
Could you please upload a sample of your excel file so I can test on my computer as it will make it easier to solve your issue.

Cheers

Voilą!

Thanks!

Hi
I do not get a runtime error however the

Please Login or Register  to view this content.

does not actually do anything.
What were you trying to achieve?

Cheers

Well, I have some files with numerous macros and with some large data set and I want to apply a sort to a range with several columns. So what I want to achieve is to first clear any previous sort
that was applied via previous macros and then proceed with a new sort. Please note that I have the same problem with the "AutoFilter.Sort.SortFields.Clear" command. I have created and attached a
new file with some data and new alternative macros to clear the autofilter. I get the same problem.

Thanks again!

Hi rorya,

I started Excel in safe mode and then ran the macro several times. Everytime Excel tries to start the macro (all alternatives) and then shuts down. Then it tries to reopen the file.

Thanks.

Alan