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/