Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Using the Union Method to Join Multiple Ranges
Sub unionDemo()
    Set UnionRange = union(range("Range1"), range("Range2"))
    With UnionRange
        .Formula = "=RAND()"
        .font.bold = True
    End With
End Sub