| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ctrl-key adds up to cells.count
This is about selecting multiple ranges in Excel using ctrl.
Say you click on A1, hold ctrl and click on A2, next A3, you have 3 cells selected. But if you accidentally click a second time on e.g. A2, Selection.Cells.Count returns 4 and if you loop through the elements within the Cells-collection, A2 is twice in it. Is there a way to obtain all discrete cells from a range? I tried with SpecialCells(xlCellTypeVisible) but no success. tia, Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Isolate UNIQUE combination of Z cells from a range N that adds up | Excel Worksheet Functions | |||
| How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| Is there a macro which adds selected/highlighted cells? | Excel Worksheet Functions | |||
| How do I control to which cells a user adds data? | Excel Worksheet Functions | |||
![chris[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
