how to add 2 ranges

  • Thread starter Thread starter kotharu
  • Start date Start date
Dim target As Range, source1 As Range, source2 As Range

Set source1 = Sheet1.Range("A1:G5")
Set source2 = Sheet1.Range("K1:L5")


Set target = Union(source1, source1)


Patrick Molloy
Microsoft Excel MVP
 
Back
Top