
Excel VBA Intersect Method for Range
In Excel VBA, Intersect Method is used to return the intersection Range (the common area in the above picture).
Syntax of Intersect Method
expression .Intersect(Range1, Range2, ...)
The intersection Range must be at least 2, in order to find the intersection area.
If intersection area exists, Intersection Method returns a Range
If intersection area does not exist, Intersection Method causes a Runtime Error, which can be avoided using "Is N...
Read More