• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Searching last row and adding 1 row below 'x' to left side

Hi, Try this.
Code: 
Sub Belle()
With ActiveSheet
    iRow = .Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1
    .Cells(iRow, 1).Value = "X"
    End With
End Sub
 
It did not worked.It should have been E13 instead of A13 as last row data is F13.

I have highlighted with Green for correct & red for wrong result
 

Attachments

  • Last Row.xlsm
    10.2 KB · Views: 4
You must log in or register to reply here.
Back
Top