Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel sheet: selection of cell or rows not visible. | Excel Worksheet Functions | |||
Problem seeing and accessing top of sheet | Excel Discussion (Misc queries) | |||
Cell selection in non-active sheet | Excel Programming | |||
Capture listbox selection to a cell in a different sheet | Excel Programming | |||
Accessing a textbox on a sheet.... | Excel Programming |