Get Started
Documentation

Intersect

Intersect(Range1, Range2) → { ApiRange | Error }

Returns a ApiRange object that represents the rectangular intersection of two or more ranges. If one or more ranges from a different worksheet are specified, an error will be returned.

Parameters:

Name Type Description
Range1 ApiRange

The intersecting ranges. At least two Range objects must be specified.

Range2 ApiRange

The intersecting ranges. At least two Range objects must be specified.

Returns:

Type
ApiRange | Error