On Sunday, November 16, 2014 9:22:58 PM UTC-8, L. Howard wrote:
If the last row of all three columns is the same, then this common little snippet does just fine. (or if B has the greater last row)


Sub HMMMM()

Sheets("Sheet7").Range("B2:D10").Copy Sheets("Sheet8").Range("B" & Rows.Count).End(xlUp)(2)

End Sub


I want that capability along with should column D have a last row greater than B or C then paste to column B using columns D's last row.

So the code can past "uneven columns lenghts" always to B and to the last row of any, should they not be the same.

Thanks,
Howard

Edit:

Maybe the line should read:

So the code can paste "uneven columns lenghts" always to B and to the greater last row of any, should they not be the same.

Howard