| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exclude one range from another
I have two variables each defined as a Range say TotalRange and
SubRange. All the cells in SubRange fall within TotalRange. Is there any way (without looping through the cells) to create a new range from the above which contains all the cells in TotalRange which do not fall into SubRange. (In other words the new range should be TotalRange excluding SubRange) Thanks - Charl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to exclude a cell(s) from a range w/o mult. ranges on any fcn | Excel Worksheet Functions | |||
| Sum a range but exclude and negative values | Excel Worksheet Functions | |||
| Need to exclude certain cells in a range | Excel Worksheet Functions | |||
| Exclude Header from Range? | Excel Discussion (Misc queries) | |||
| Exclude blank cells from a range? | Excel Programming | |||
Threaded Mode
