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.
