Loop only runs if-statement one time

[fokka]

Hello,

Im trying to copy over rows from one sheet to another using a loop and a condition based on the text color. Problem is that it only loops until the first row where the condition is met, copies that row and stops. When runned in step debugging mode everything is functioning properly.

Please Login or Register  to view this content.

[DarkF1ame]

Hello fokka,

To be honest in a hastily-prepared sample worksheet attempting to replicate your problem everything worked fine for me...The only thing I see about your code is that it leaves the last copied row selected, maybe that's messing something else up about your code? Maybe throw another sheet selection after the copy:

Please Login or Register  to view this content.

I hope that helps. Alternatively, if you don't have sensitive data it is always helpful to upload your actual worksheet so we can all be working in the exact same environment.

DarkF1ame

[fokka]

Thank you for the quick reply.

No difference sadly.

I can try to mock up a dummy-file to share here and upload

[fokka]

The other workbook must be haunted or something. Everything works in the dummy-file, so i copied everything over there and it's now working perfectly.

[DarkF1ame]

Odd...ghosts in the machine!

Hope all keeps running well, if not, feel free to ask for more help.