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

Not sure, but expect you will have to track and capture
the mousemove events


-----Original Message-----

Well, by last cell i mean the most distant from the first
selected(ActiveCell) in the selection..that's the problem!
For the ActiveCell is easy:
diXLSContainer1.Application.ActiveCell.Column;
diXLSContainer1.Application.ActiveCell.Row;

How can i get these values for the most distant cell in

the selection,
not the ActiveCell?


--
gnosis
----------------------------------------------------------

--------------
gnosis's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=16806
View this thread:

http://www.excelforum.com/showthread...hreadid=320055

.