Pasting into the last Row

  • Thread starter Thread starter Farley Granger
  • Start date Start date
F

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
 
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
 
Remember to add one if you don't want to overwrite the data existing in the
current lastrow.
 
Back
Top