Pasting into the last Row

[Farley Granger]

I'm writing a macro to copy data from one sheet and past it into the last
row of a different worksheet.
Since that worksheet contains several rows, how do I identify where that
last row is on the worksheet?
Dennis

 

[BS]

You can use this macro to find the last row in column A

sub lastrow()
Range("A65536").select
Selection.End(xlUp).Select
lastrow=activecell.row
End Sub

Burçin SARIHAN

 

[Dave Peterson]

Remember to add one if you don't want to overwrite the data existing in the
current lastrow.

 

[Dale Hymel]

Range("A1").End(xlDown).Offset(1, 0).Select