What do you mean by processing blank values?
- I mean I want to put the status “Error: Some fields are blank” in the status column
And also currentrow = Nothing is wrong syntax…and if you want to check if any of the column in current row is blank then currentrow.itemarray.contains(string.empty) is more appropriate
-Oh thank you for the knowledge, I just know it
And the comparison of currentrow.tostring= row.tostring will also be always true because both return system.data.datarow …here as well you are not comparing the values ypu are comparing the type of those rows
-Yeah, I tried to use CurrentRow(“ColumnA”).tostring=Row(“ColumnA”).tostring too but when I tried it in loop when there is another same row value, the loop failed
If you can share a sample input and smaple output that would be help because as of now i see what you are trying and what you wrote are two different things and of which , what you want to do is also not very clear to advice on what to do next
-So the first thing I want to put status for each blank row for each sheets (sheet1 and sheet2) then I need to put Receiving System and Roles in loop for each User ID which first need to be CurrentRow(“A”).tostring=Row(“B”).tostring
But somehow for each activity failed to loop it
hopefully my answer will help and please help me