Hi, can some please tell me whats the problem of my code, i have a DataTable which is DT and have to update the column operation ID, but the problem is when I used to watch the DT it has everything correct including the operationID on all the rows, I have 2 row to be exact but then I use the write range it seems that it is only saving the value of the operationID in the first row then the second row value is also the value of the first.
I put the updating of the operation ID in a For each loop then the Write range after the for each loop.
item.ToString is the sheetname
Update Row Item is the one im using to update the operation ID:
This is my write range: