How to combine two ranges vertically ?

[mrchonginhk]

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

 

[sandy666]

Use PowerQuery and Append feature, Append R2 to R1

 

[jolivanes]

Range("Range2").Cells(2).Resize(Range("Range2").Rows.Count - 1).Copy Cells(Range("Range1").Rows.Count + 1, Range("Range1").Column)