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)