How do I find the number of last row and paste right below it?

Asked Jan 13 '23 at 12:35

Active Jan 13 '23 at 13:52

Viewed 29 times

I need to paste data from one sheet to another but the last row of data varies everytime. The line I use to paste the data is "Application.Goto ActiveWorkbook.Sheets("CICLICO").Cells(LastRow+1, 2)"

If my LastRow is 10 I paste the data at the row 11, but it can be 9, 50, 89... I would like a code to find that last row and identify it as LastRow. Any ideas?

I haven't tried anything because I don't know how to do it.

edited Jan 13 '23 at 13:36

Ike

9,580
4
13
29

asked Jan 13 '23 at 12:35

Lucas Tezolini

something with `.End(xlDown)`. – Dominique Jan 13 '23 at 12:40
this might help https://stackoverflow.com/questions/38882321/better-way-to-find-last-used-row – user10186832 Jan 13 '23 at 12:40

How do I find the number of last row and paste right below it?

0 Answers0