Find first non blank cell in column with vb.net

Question

In an Excel table, how do I find the first cell containing data?

Answer 1

you can use this link

you can also use

    If xlDataSheet.Cells(1, iCurrDataColumn).value Is Nothing Then 
    '.... do something 
    else
    '.....do something