Range Intersect « Excel « VBA / Excel / Access / Word






1.Using the Intersect Method to Create a New Range from Overlapping Ranges
2.Use Intersect when you want to find the cells that are common to two or more ranges, or in other words, where the ranges overlap.