Autofilter error - Autofilter Method of Range class failed

How to handle error in AutoFilter Method while using Excel Macros -

Error - "autofilter method of range class failed"

Reasons -

because the rows might be blank

It's caused because your data is not laid out for AutoFilter. To use AutoFilter the data has to be in a table layout with a Header, with no empty rows or columns.

Solution-

select the complete range of values and then do selection.autofilter