Problems with IF Conditions;

hello guys,

So, im creating an automation to get all the numbers that are inside a range of two cells on excel, but when the second cell is blank, the value in the first cell have to complete the second one. Im trying to use a “If” condition, but this “If” is inside a “for” loop, that read a row, execute and go to the next row.

The problem is: I tried to make the “If” condition read the second row and check if it is empty but the command that im using (String.IsNullOrEmpty(CurrentRow.item(1)) = True or False) read only strings and im trying to read a object. Would like to know if there is any solution for this.


Can you try to add .ToString() as the following?



HI @g.vanderlei

Try with this expression?


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