Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

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 together:

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
  • + Share This
  • 🔖 Save To Your Account