Filter and Copy to another worksheet a table object - VBA

Hi,


I am trying to filter a table object (tabProgrammes) and copy the results to Sheet2. Could you please have a look at this code?
It give a syntax error (see code).

Thank you so much.

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Thank you AB33 - it works perfectly, and fast!


Note: This forum (with people like you) is just amazing! Thanks...