Macro works for several loops and then slows down

Hi all,

I am running the following macro in order to take rows from one sheet, and based on the contents of particular columns, pasted those rows into another sheet.

Please Login or Register  to view this content.

The above seems to run for around 25 rows and then it slow down (taking around 30+ seconds) to process each row.

Assuming that the sheets are formatted correctly and the relevant data is present, is there any reason why this may be occurring after a seemingly random amount of loops?

Thank you.

You can speed up the copy buy using ranges in vba instead of selecting. The selection takes time and is unnecessary.