Problem when copy filtered table in Excel 2007 using VBA

Hello Guys, I am trying to copy and paste a filtered table (named table1) which is in the sheet DATA through a macro, but , when I execute the macro, there are rows that aren't copy.

I copy the filtered table using the VBA code:

Please Login or Register  to view this content.

An example workbook is attached.

Someone can help me, please, any help is welcome, thanks in advance.

You missed out the criteria for filter in your code

I discover my problem,this is, the table "table1" is filtered , so, there is rows that are hidden, when I copy and paste the filtered rows in the right side of my filtered table , the hidden rows stay hidden , so , I can't see someone rows that I copy from the original filtered table.The solution is remove the filter to the filtered table with the code : ListObjects("table1").Range.AutoFilter. Thanks tehneXus.

This worked for me. Only the filtered (and thus, visible) rows are copied. The data was filtered with another macro. Hopefully it will helpful to others.

Please Login or Register  to view this content.