PIA interop Excel - VB.net accessing Cell
 

Hi,

I'm using PIA (Primary Interop Assembly) to drive Excel from vb.net code.
I'm facing the problem in the code to retrieve the row number of the last
used cell in an excel worksheet.

I've found the last used Cell is accessible from
'myWorksheet.Cells.SpecialCells(Excel.XlCellType.x lCellTypeLastCell'
but can't figure out how to retrieve the row number.

any help much appreciated.
Thx,
C