Find the last cell used and then paste what has been copied below

[TkdKidSnake]

Hi all,

I know how to find the last populated cell in column A however how do you paste the rows that I have copied below the last used?

Thanks in advance

 

[Fluff]

Maybe

   Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial

 

[DanteAmor]

May be like this

  lr = Range("A" & Rows.Count).End(xlUp).Row + 1
  Range("A" & lr).PasteSpecial xlPasteValues

 

[TkdKidSnake]

Works a treat thank you.

Maybe

   Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial

 

[Fluff]

You're welcome & thanks for the feedback