Paste in range of data to match with another column length - VBA

[Apple08]

Hi

I have to paste in the last row data of Columns A & B up to the last row of column L. For example if the last row data of columns A&B are A18 & B18, and the last row data of column L is L30, then I need to paste in A18 data up to A30, B18 data up to B30 to match up with the last row of L.

Please could anyone help to tell me a dynamic way to do that. Many thanks.

 

[SteveO59L]

Dim c As Range, rng
Dim lastRow1 As Long
Dim lastRow2 As Long
lastRow1 = Cells(Rows.Count, "l").End(xlUp).Row
lastRow2 = Cells(Rows.Count, "a").End(xlUp).Row
Range("A" & lastRow2 & ":A" & lastRow1).FillDown
lastRow2 = Cells(Rows.Count, "b").End(xlUp).Row
Range("b" & lastRow2 & ":b" & lastRow1).FillDown

 

[Apple08]

Thanks very much! It works perfectly! Please I would like to ask about the meaning of Dim c As Range, rng. I understand Dim c as Range but unsure about rng. Also it looks like c hasn't been used within the VBA?