Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert image into cell using C# and Excel interop?? Michael Howes Excel Programming 0 December 7th 06 11:14 PM
Accessing oracle database through excel cell coeus Excel Discussion (Misc queries) 8 August 10th 06 01:48 AM
Can't Find Excel Interop reference Steve B.[_3_] Excel Programming 0 November 1st 05 03:19 PM
Excel interop versions Maik Excel Programming 2 May 16th 05 09:32 PM
Displaying multiline Text into Excel Cell through Interop Karthikeyan Excel Programming 5 July 5th 04 04:23 PM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"