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