Union Method

Applies To

Application Object.

Description

Returns the union of two or more ranges.

Syntax

object.Union(arg1, arg2, ...)

object

Optional. The Application object.

arg1, arg2, ...

Required. Return the union of these ranges. At least two Range objects must be specified.

See Also

Intersect Method.

Example

This example fills the union of two named ranges, Range1 and Range2, with the formula =RAND().

Worksheets("Sheet1").Activate
Set bigRange = Application.Union(Range("Range1"), Range("Range2"))
bigRange.Formula = "=RAND()"