Seems like it would be better to read the whole sheet into a datatable, manipulate the data in the datatable, then write the datatable back to the sheet. It’s a lot less reads and writes.
Ok, I hate to be so dense but while i totally understand your logic I still cannot make it work.
Here is the link to my project, if you could please review and point out my mistake, i would like to learn correctly.
Tanxs so much for taking the time but my question was a bit different.
The for each row get me all the row. : good
I need to read some a specific Columns, in our case, i call it Administrator.
I need to process my regex for each cell in the row 1, columns Administrator
AND THEN. move to row 2, Columns Administrator
And finaly, when i have done all the row of columns Administrator, I need to start again
but with the next columns, lets call it Administrator2 and do it all over again.
I want the robot to do it as long as he find new columns.