Copy Paste On The Following Row VBA

[Lauren123]

Hi, I have this Macro where it select a range and paste it on a specific cell, is there a way it can do it on the following of the last row.



Sub CopiaDetalle()


Dim rng As Range


Ultimafila = Range("C" & Rows.Count).End(xlUp).Row


With Sheets("U-Detail")
Set rng = Range("C11:AC" & Ultimafila)
rng.Copy
Worksheets("Detail").Range("C11").PasteSpecial xlPasteValues
End With


End Sub

 

[Yongle]

instead of

Worksheets("Detail").Range("[B]C11[/B]").PasteSpecial xlPasteValues

perhaps

Worksheets("Detail").Range("[B]C[/B]" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValues

does column C always have a value in every row?