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
[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]