autofilter method of range class failed -header has tables headers and non table headers

HI

I am consolidating data from different workbooks to a single sheet.
In the WSR Consolidation excel, in the ‘LIST’ sheet I have created a Name ‘CritList with filter details.

I am filtering multiple data rows.
Columns A,B and C are normal columns but Column D and E are tables.
Column D and E are tables since there are formulas defined for Dependent drop down.

I am getting an error
Run time error 1004 autofilter method of range class failed

Please find the code and sample file.

Please suggest how to resolve the issue.

Please Login or Register  to view this content.

Regards,
Naveen N