ForEach loop problem

Dear Users,



my goal is to copy all of the numbers from the "copyPaste" sheet to the other sheet which are between 41000000 and 42000000.

If I run the code below it only gives the last value that is between these two. (it is also very slow...)

Can you spot the mistake?

(since I am a rooky I would learn the most if there would be as many changes as it is necessary if you add to it.. the goal is mainly to know my mistake than realy get the values)

Please Login or Register  to view this content.

Thank you indeed for your time and help

please see attachment

Without a loop

Please Login or Register  to view this content.