ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to detect selected cells in Excel, in VSTO (https://www.excelbanter.com/excel-programming/379459-how-detect-selected-cells-excel-vsto.html)

Hung[_2_]

How to detect selected cells in Excel, in VSTO
 
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


abhimanyu

How to detect selected cells in Excel, in VSTO
 
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



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com