How to combine two ranges vertically ?

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
672
I have two ranges: R1 and R2. They have same header
How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"?

Thanks
 

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,390
Code:
Range("Range2").Cells(2).Resize(Range("Range2").Rows.Count - 1).Copy Cells(Range("Range1").Rows.Count + 1, Range("Range1").Column)
 

Forum statistics

Threads
1,078,134
Messages
5,338,428
Members
399,232
Latest member
stevenmoritz

Some videos you may like

This Week's Hot Topics

Top