If I have A2 and B1 selected, which is the cell you are looking for?

In otherwords, for a single rectangular selection, the last cell is the
lower right cell, but you say you have no problem getting that - thus you
problem is with a multi area selection and in that case, it is not clear
what constitutes the last cell. What are your rules.


--
Regards,
Tom Ogilvy



"gnosis" wrote in 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...o&userid=16806
View this thread: http://www.excelforum.com/showthread...hreadid=320055