Find last row without counting the first one in the sheet

[Adi21]

Hi, I want to find the last row in a sheet, but without counting the first one.
The first row is the top of the tabel and it`s posibile that I don`t have dates, but the first row is there and after that I have to copy the dates from that file to another and is copied the first row when the other rows are empty.
It`s posible to modify this code:

LR = Sheets("Faza2").Cells.Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row

to run only from the end to row2(if there is only first row).
Thanks

 

[Darren Bartrup]

Surely the last row in the sheet will always include the first row? If row 10 is the last row, and you tell it to ignore the first row then the last row will still be row 10?

So.... if LR = 1 and you want to ignore it then just set it to 2, otherwise leave it as it is.

    LR = Sheets("Sheet1").Cells.Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
If LR = 1 Then LR = 2