Exclude one range from another

[Charl]

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

 

[Charl]

Thanks, however I do not wish to delete the contents from SubRange - I
need to return a new range which contains TotalRange excluding SubRange
(all cell content needs to remain unchanged)

Regards
- Charl

 

[Norman Jones]

Hi Charl,

The following NG thread maybe of interest:

http://tinyurl.com/bzohw