find ecxel last row value

See more:

VB

MS-Excel

I want to parse the value of last row of an Excel worksheet af a cell, here is my code wich returns the First row cell value :

Dim instance As XlFileAccess
       workbook = APP.Workbooks.Open("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")
               worksheet = workbook.Sheets("stats")
               Dim lastrow As Range = worksheet.Rows.End(XlDirection.xlUp)
            TextBox2.Text = worksheet.Rows(lastrow.Row.count, 2).Value
       workbook.Save()
       workbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")

       APP.ActiveWorkbook.Close("C:\Users\supervisor\Documents\Visual Studio 2008\projects\email\email\email stats2.xlsx")
       APP.Quit()

   End Sub