For Each Row question

Hello and thank you in advance,

I have scraped a data table from a website and I’m using a For Each Row activity to iterate through each row. My issue is that I only need to iterate until the activity finds the text Trace in one column and Work In Progress in another column. How do I get the For Each Row to stop when it finds what I need? Or do I need to use something else instead?

Thanks again

I just figured out I can use an If statement

You can use the ‘break’ activity once your condition is found. So if row.item(“column1”) = “Trace” AndAlso row.item(“column2”) = “Work In Progress” Then Break

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.