Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can vba detect what is currently selected? | Excel Programming | |||
How to detect row number of selected cells? | Excel Programming | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Programming | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
Detect selected chart point | Excel Programming |