Speeding up loop code

[Mrowe]

I'm currently running code which compares two columns from different worksheets, "Original" and "Updated", and copies the entire row to a new sheet when a match is found. When running through tens of thousands of rows, the code takes too long to execute. I know this can be sped up using arrays, but I'm not too familiar with working with arrays yet. Could someone help me out? Code is below.

Please Login or Register  to view this content.

Thanks

[nilem]

Hi, Mrowe. Maybe this option will be faster, try

Please Login or Register  to view this content.

[Mrowe]

Worked perfectly, thank you nilem.