Union Method Example

This example sets a variable to the smallest rectangular range that contains range A1:A5 and range F1:F10.

Set r1 = Spreadsheet1.Range("a1:a5")
Set r2 = Spreadsheet1.Range("f1:f10")
Set ur = Spreadsheet1.Union(r1, r2)