Excel Automation and VB Expression

Help
1

Here is used a VB expression to return the adjacent column if status=‘fail’ or ‘no response’.
My doubt is how to write the same if there is the cell is empty?? I have tried status= null/space it didn’t work. Thanks in advance :slight_smile:

Capture

2

have you tried text.tostring.equals(“”)?

3

Can’t get you. Where exactly i need to type this code?? Can you please elaborate??

4

Do you have datable?
If yes, you can through datatable and check value of cell in every row.