Auto filter method of range class failed with Criteria

Question

Set rmdvsheet = ActiveWorkbook.Sheets(11)

    rmdvsheet.Range("A1:K103").AutoFilter Field:=10, Criteria1:= _
        "D7u L462-L494 17MY"

Here on 2nd line i am geting an error saying "Auto filter method of range class failed".

Answer 1

Your problem is with the range you've defined. The autofilter only wants referral to the header row. If you sub this into your code, it should work the way you expect (the only change is in the range from K103 to K1"):

rmdvsheet.Range("A1:K1").AutoFilter Field:=10, Criteria1:="D7u L462-L494 17MY"

Answer 2

I had the same problem. If you are turned to the right sheet and no other syntax error. It's because maybe in the original sheet, it is already autofiltered. Like in the following picture. To solve this, just click the filter button to return to the unfilter status.