View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Determining if two ranges overlap

Hi
try
If Intersect(range1, range2) Is Nothing Then 'no overlapping
--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

I am trying to write a piece of code that will enable me to validate
two ranges to determine whether or not they overlap. I can determine
fairly easily if one is contained wholly within the other but not if
they only partially overlap. Any suggestions on how I could approach
this problem would be appreciated!

Thanks,
Mark


---
Message posted from http://www.ExcelForum.com/