[2005:Win App] Finding the last line of an Excel file

[rajabadsha]

I am trying to find the last line of an existing Excel file from Vb.net. I figured out how to open the file. The file has contents in its first columns as follows:

FRPN

1997
1
2
3
4
5
.
.
50

I need to find the cell where the integers ended, i.e. the first empty row after the last integer. Can anyone help.

Thanks

[AnthonyGrimes]

I believe it is something like the following:

LastRow = ObjWorksheet.UsedRange.Rows(ObjWorksheet.UsedRange.Rows.Count).Row

ObjWorksheet As Excel.Worksheet