Comparing Ranges in Excel
- by mcoolbeth
In the Excel Interop libraries, is there functionality to determine whether a given Range object is contained within another Range object?
It would be simple enough for me to compare the row and column indices of each Range, but things become more complicated when you want to compare two ranges that may be on different worksheets.