Determining if two ranges overlap
From: Marky (Marky.11s2b3_at_excelforum-nospam.com)
Date: 02/17/04
- Next message: Tom Ogilvy: "Re: Convert a 100,000 character linear text file"
- Previous message: Tom Ogilvy: "Re: Find"
- Next in thread: Frank Kabel: "Re: Determining if two ranges overlap"
- Reply: Frank Kabel: "Re: Determining if two ranges overlap"
- Reply: Bob Phillips: "Re: Determining if two ranges overlap"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Feb 2004 09:48:41 -0600
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/
- Next message: Tom Ogilvy: "Re: Convert a 100,000 character linear text file"
- Previous message: Tom Ogilvy: "Re: Find"
- Next in thread: Frank Kabel: "Re: Determining if two ranges overlap"
- Reply: Frank Kabel: "Re: Determining if two ranges overlap"
- Reply: Bob Phillips: "Re: Determining if two ranges overlap"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|