Excel Developer Home > Excel Object Model Reference > Application Object > Methods
Returns a Range object that represents the rectangular intersection of two or more ranges.

expression.Intersect(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)

Return Value
Range

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
Arg1RequiredRangeThe intersecting ranges. At least two Range objects must be specified.
Arg2RequiredRangeThe intersecting ranges. At least two Range objects must be specified.
Arg3OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg4OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg5OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg6OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg7OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg8OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg9OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg10OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg11OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg12OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg13OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg14OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg15OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg16OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg17OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg18OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg19OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg20OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg21OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg22OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg23OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg24OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg25OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg26OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg27OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg28OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg29OptionalVariantThe intersecting ranges. At least two Range objects must be specified.
Arg30OptionalVariantThe intersecting ranges. At least two Range objects must be specified.

Example

This example selects the intersection of two named ranges, rg1 and rg2, on Sheet1. If the ranges don't intersect, the example displays a message.

Visual Basic for Applications
Worksheets("Sheet1").Activate
Set isect = Application.Intersect(Range("rg1"), Range("rg2"))
If isect Is Nothing Then
    MsgBox "Ranges do not intersect"
Else
    isect.Select
End If

See Also