Copy and Delete Filtered Range

[efernandes67]

Hi

See file in attach.

I have 2 sheets that have 1 table each.

When I run th macro 'cpyRecords' some records in table1 are filtered based on 'sub RecordsFilter1' and then copied to table2 in sheet2 and then the same rows are delete from table1. Everything works ok

If in' Sub cpyRecords' I put 'Call RecordsFilter1(Date - 1)' as a comment and before running the macro, I filter the records by hand, then all the records are copied to table2 and then deleted from table1.

The result sould be the same. What do need to change to make it work?

Regards,
Elio Fernandes

[arlu1201]

I checked your macro and it works fine. Are you trying to say that your macro is not doing it correctly v/s your manual actions?