Excel VBA error 1004 when working with a large file

a Simple script written VBA compare two tables from two different files produces an error 1004 run-time error when you try to work on a large (5 MB) xls file. Or not work out.
You must adapt the script to work correctly.
For