Thread: Dont intersect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JethroUK© JethroUK© is offline
external usenet poster
 
Posts: 49
Default Dont intersect

if:
application.intersect(rnga,rngb).select

selects the range where both ranges intersect

how do i select (identify) the range where they DONT intersect?

or is there a method of UNunion? - i.e remove a range from an existing
range?