advanced filter macro doesn't work on large data set

Hi everyone on the forum, I’m new here to post.

I have troubles with a large set of data (43’600 lines x 27 rows) that I want to filter with an advanced filter. I want to filter many times according to changing criteria, so I record a macro for an advanced filter with copy to a different place. The problem is that when recording the macro the filter applies and I get the filtered set at the indicated location -> . But when running the macro nothing is being filtered -> (the only two things that happen is that two named fields are created (“Criteria” and “Extract”) and at the location of the extraction the header row is written).

I tried the same procedure with a really small set of data (12 lines x 3 rows) and it works fine -> . Any ideas? If of any help I can send the file.

Any help is very much appreciated. Thank you in advance everyone.

See also here for a similar question:
http://www.excelforum.com/excel-prog...ot-in-vba.html