So I was trying to remove a datarow inside a For each row loop if something gave an error. Sadly, it gives the collection was modified error. So I decided to get all the Column 1 values that had an error, since each value of it is unique. Now, I am trying to remove the rows by doing something like.
For Each Item in List of Errors
Delete Row Where Item Is Equal to Row(0)
Is there a work around here? Thank you.