View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zbigniew Malinowski Zbigniew Malinowski is offline
external usenet poster
 
Posts: 3
Default Range Minus operator?

Hi,

I'm working on an Excel 2000 application. It could be very useful if I could
use something like MINUS operator for Range objects.

Ex. I can do INTERSECT to find a common Range. I can use UNION to find a sum
of Ranges. But can I find a part of a Range that is not included in another
Range object?

I'm surprized but I'm unable to find something like this.

Any help apprectiated

Zbig