PIA interop Excel - VB.net accessing Cell

C

Chris Le Roquais

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Way to Override Policy & Use 2003 Vice 2007 Excel Interface (VB.NET)? 1
VB.NET Inserted Picture Ends Up in Wrong Cell 1
Using a typeconverter in Excel PIA assembly 0
VB.NET with Excel VBA 3
Quickly count used rows? 5
Unable to cast com object (interop) 0
Retrieving data from a cell in the last row containing data in the worksheet 1
Passing arrays from Excel (VBA) to C# uisng COM interop 0

Top