I’m reading some cell values from excel sheet and displaying the results based on some condition in (IF). It will work fine if all cell have values but will throw an error if the first cell is empty. : " Object not set to instance of Object "
I’m reading cell B6 B7 B8: if all have values the result is fine
If B7 or B8 is empty: result is fine.
But if B6 is empty I’m getting this error " Object not set to instance of Object "
If I display value B6 outside the loop I get empty message, but inside the for each loop If condition this error comes.
FYI: reading cell values and column A20 and looping the column value based on IF condition.
you can do this row("yourColumnName).ToString.Contains(Item.ToString)
and check if you are using two different for each loops make changes accordingly!
cheers @batBot