This topic has not yet been rated - Rate this topic

RectUnion Method

Office 2003

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



Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.