View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gnosis gnosis is offline
external usenet poster
 
Posts: 1
Default accessing last cell in selection on sheet


Well, i'm writing an application in delphi and i use XLSContainer to
access the cells in an xls document.
I need to find a method that would help me to get the
coordinates(column,row) of the last selected cell in the selection.

so far found this methods:
XLSContainer1.Application.ActiveCell.Column
XLSContainer1.Application.ActiveCell.Row
XLSContainer1.Application.ActiveWindow.RangeSelect ion.Columns.Count
XLSContainer1.Application.ActiveWindow.RangeSelect ion.Rows.Count
XLSContainer1.Application.Range[str,str].Activate

With these methods i've managed to access all cells but only when the
selction goes
from left to right and from up to down....If i could get he
coordinates(column,row) of the last selected cell in the selection i
will solve my problem!

Hope that you understand what i wrote:)
koko


--
gnosis
------------------------------------------------------------------------
gnosis's Profile: http://www.excelforum.com/member.php...o&userid=16806
View this thread: http://www.excelforum.com/showthread...hreadid=320055