Excel Automation and VB Expression

net

#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.