Excel 2016 VBA error for using method 'AutoFilter' RRS feed

  • Question

  • I created a VBA program, it's OK before(Some workmates use this program). Since July last year, three workmates have reported errors when using this code. located at using the method AutoFilter. The error message is that "Method AutoFilter of  object Range failed”. 

    Is there anyone who has good opinion? Thank you.

    Eror page

    When recording VBA codes for filtering and sorting, the recording codes are: SortUsingCustomLists

    Tuesday, March 5, 2019 10:40 AM

All replies

  • The protection cause this

    Guy Zommer

    Thursday, March 7, 2019 12:09 PM
  • What protection do you mean ? I create a new workbook,and use method "AutoFilter" , this problem still exists. How can I fix this problem. Thanks for your reply.
    Monday, March 11, 2019 2:32 AM