Thread: [Solved] Go to second last blank row
View Single Post
 
Old 05-14-2020, 05:20 PM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Perhaps this
Code:
Sub Dave_T()
    Dim lr As Long, i As Long
    lr = Cells(Rows.Count, "A").End(xlUp).Row
    For i = lr To 1 Step -1
        If Cells(i, "A") = "" Then
            Cells(i, "A").Select
            Exit For
        End If
    Next i
End Sub
Reply With Quote