Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

Using the Intersect Method to Create a New Range from Overlapping Ranges

The Intersect method returns the cells that overlap between two or more ranges. If there is no overlap, an error will be returned:

Application.Intersect(argument1, argument2, etc.)

The expression Application is not required. The following code colors the overlapping cells of the two ranges:

Set IntersectRange = Intersect(Range("Range1"), Range("Range2"))
IntersectRange.Interior.ColorIndex = 6
  • + Share This
  • 🔖 Save To Your Account