Run-time error ‘1004’: AutoFilter method of Range class failed

Problem:  Macro debugging on Cells.AutoFilter with error message “Run-time error ‘1004’: AutoFilter method of Range class failed”.

Solution:

Range("A1").select

ActiveSheet.AutoFilterMode = False

ActiveSheet.Range("A1:B1").AutoFilter