![]() |
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 |
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