How to combine two ranges vertically ?

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

jolivanes

Well-known Member
Joined
Sep 5, 2004
Messages
1,457
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,089,656
Messages
5,409,561
Members
403,271
Latest member
Rajeev Muraleedharan

This Week's Hot Topics

Top