Home |
Search |
Today's Posts |
#19
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have I missed something?
Yes. Function NotIntersect(rng As Range, x As Range) As Range rng is the source x is the range to be removed from the source I presented the function in such a way that x should be a single-area range, because calling the function within a loop... for each x in bigx.Areas NotIntersect(Selection, x).Select ....or whatever, would be a trivial exercise for the reader, and would detract from understanding the basic and very simple concept of what my code achieves, extremely efficiently. -Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) | |||
help with algorithm | Excel Programming |