[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

PIA interop Excel - VB.net accessing Cell

christophe.leroquais

12/19/2006 8:53:00 PM

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.xlCellTypeLastCell'
but can't figure out how to retrieve the row number.

any help much appreciated.
Thx,
C