Referring to ranges

Using the Union method to join multiple ranges

The Union method enables you to join two or more noncontiguous ranges. It creates a temporary object of the multiple ranges, which enables you to affect them at the same time:

Application.Union(argument1, argument2, etc.)

The expression Application is not required. The following code joins two named ranges on the sheet, inserts the =RAND() formula, and bolds them:

Set UnionRange = Union(Range("Range1"), Range("Range2"))
With UnionRange
     .Formula = "=RAND()"
     .Font.Bold = True
End With