How to detect selected cells in Excel, in VSTO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hung - 14 Dec 2006 22:25 GMT

in VSTO 2005, is there a way to get hold of the selected cells.

Say, user hold the Ctrl key and select multiple cell, is there a way to
get hold of them in VSTO? ActiveCell doesn't seem to be the answer.

THanks a lot
Wei

Reply to this Message

abhimanyu - 15 Dec 2006 04:09 GMT

I suppose Application.Selection will give you a range of selected
cells.
The Selection object can hold any selection (cells, Pictures etc) so
before using it , check the type it holds by using the as operator like
(Selection as Range). If this returns null, Selection object does not
contain a Range.
Also, there are Areas inside Range, used in case of non-contiguos
selections.

regards

Reply to this Message