To ID blank cells in an excel file


I have an excel sheet with large no. of rows. I want to identify the cells with blank values. Right now I have used an advanced loop and used the expression " outres.item(1).tostring.Length.Equals(0) " to find the blank cells. The blanks cells are int/double type. Is there a direct function to find out the blank cells other than this way?

Thanks for the help

Hi Stevin,

There is no direct function for the same

Amit Anand

Thanks Amit.