Hi Excel Monkey,

See the archive thread:

algorithm to INVERT a multiarea selection ?
http://tinyurl.com/5gqu29




---
Regards.
Norman


"ExcelMonkey" wrote in message
...
I know I can use the Intersect function to return the address where two
ranges intersect. The code below will equal N2:BE2 as this is where the
ranges overlap.

InterectString = Intersect(Range("N2:BE2"), Range("N2:BF2")).Address

Is there a way to return the portion of the range where they do not
intersect (i.e. BF2).

Thanks EM