Advanced Filter Macro - Won't run the filter

Hi -

I am using the below code to fun an advanced filter and copy the data to a new destination - when I do this manually the advanced filter works - however when running the macro i get an error message - "Run-time error '1004' the extract range has a mssing or illegal field name." Can someone please help me fix this error.

Please Login or Register  to view this content.

Thanks,

Hi,

Can you please upload the xls file So that we can look into what exactly is happening ?

Regards,
Naras

I would prefer not to attach the file - is there any other way to help on this?

Hi,

Apologies. I couldn't help you.

Alternative Suggestion : You can change the column names. Leave only small amount of data which is not the real one. This will maintain the confidentiality.

Naras

Thanks Naras - I created the same type of file and I am still having the same issue - I have attached via zip. Thanks for your help.