Share via

RectUnion Method

  • Article

Returns a Range object that represents the smallest range of cells that includes the union of the specified ranges.

expression.RectUnion(Range1, Range2)

*expression   * Required. An expression that returns a Spreadsheet object.

Range1*   Required **Range.*

Range2*   Required **Range.*

Remarks

This method always returns a rectangular range. For example, if you specify A1:A5 and F1:F10, the return value is the rectangular range A1:F10. Also, you cannot use this method to create a range containing noncontiguous areas.

Applies to | Spreadsheet Object

See Also | RectIntersect Method