Add the last row

[BJS1002]

Hi

I have a sheet I want to be able to look for the last record or last row of data and paste new records from another sheet
The layout for both sheets are the same, just not sue about the lastrow function

 

[Joe4]

You can find the last row in column A with data like this:

LastRow = Cells(Rows.Count,"A").End(xlUp).Row

 

[DanteAmor]

lastrow  = range("A" & rows.count).end(xlup).row + 1

 

[Joe4]

lastrow = range("A" & rows.count).end(xlup).row + 1

That is really "first blank row", not "last row", right?
Ultimately, that is probably what they are really after.