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


Well, by last cell i mean the most distant from the firs
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

--
gnosi
-----------------------------------------------------------------------
gnosis's Profile: http://www.excelforum.com/member.php...fo&userid=1680
View this thread: http://www.excelforum.com/showthread.php?threadid=32005