VBA Fill to last Row

Good day all,

I am trying to write a macro that would time by time point at the very last cell in a row and autofill down to the next cell (blank). I've unsuccessfully tried several ways as the cell changes as I add new records. Anybody out there can help me? Thanks

Not sure I understand, does this help any?

Sub leandrofernandez()
Dim lr As Long

lr = ActiveSheet.UsedRange.Rows.Count

Range("A" & lr).Select

End Sub