| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to invert Range-selection
Hello
In my Excel 2000 VBA programm I'm selecting a range of disjointed cells in a row. Afterwards I want to invert this range: select all cells which weren't selected and unselect all cells which were selected. Does there exist any function or easy way to do this? Thank you Sincerely Lore |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Function to invert Range-selection
Hi
no build-in function available. But see this thread for some code (have esp. a look at the code posted by Jim Wilcox) http://tinyurl.com/4tu6d -- Regards Frank Kabel Frankfurt, Germany "Lore Leuneog" schrieb im Newsbeitrag ... Hello In my Excel 2000 VBA programm I'm selecting a range of disjointed cells in a row. Afterwards I want to invert this range: select all cells which weren't selected and unselect all cells which were selected. Does there exist any function or easy way to do this? Thank you Sincerely Lore |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you invert your selection of cells in excel? | Excel Discussion (Misc queries) | |||
| How can i invert the selection of cells in Microsoft Excel 2007 | Excel Worksheet Functions | |||
| How do I invert a selection in Excel 2007? | Excel Discussion (Misc queries) | |||
| Invert Excel Selection | Excel Discussion (Misc queries) | |||
| algorithm to INVERT a multiarea selection ? | Excel Programming | |||
Linear Mode
