Union Method

  • It combines the multiple Ranges
  • Download The Workbook

     

    Sub Union_MultipleRanges()
    Union(Range("A1:A5"), Range("C5:C8")).Select
    Union(Range("A1:A5"), Range("C5:C8")).Interior.ColorIndex = 9
    End Sub