Loop is stopping half way

[pedro53]

Hi,

I have the following code that loops through a Column that contains "Failed" and "Passed" in a workbook. I just realized that in the workbook there are 10 items that have "Failed" and its only copying like 5 of them. for me to get all ten items copied over I have to run it twice and that's a pain when I have a lot of values.

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Could you attach a desensitized version of the file so we can see it in context?

BSB

[Fluff13]

Make sure that the cells say Failed, rather than failed or FAILED as VBA is case sensitive.
Also check for any leading/trailing spaces.

[pedro53]

Here's how the Workbook looks like

Attachment 710571


Everything is fine it's just not picking up all the data. If you need anything else let me know

[BadlySpelledBuoy]

That attachment doesn't work for me. Follow the instructions in the yellow bar at the top of the forum for details on how to attach a file.

BSB

[mehmetcik]

Your Code is full of Errors

Please Login or Register  to view this content.

Please Login or Register  to view this content.

If you have a lot of data then this solution will be a lot faster:

Please Login or Register  to view this content.

[pedro53]

You're right mehmetcik there are some errors I didn't realize that. I made a small code of the actual code.

Please Login or Register  to view this content.

So the code above is a more accurate.