Total Pageviews

Monday 26 August 2019

Finding last row used in Excel worksheet

Efficient code available to find the last row used in worksheet would be :


Sub Find_LastRow()
      Dim lngLastRow      As Long
      lngLastRow = Sheets("sheet_name_here").Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row
      Debug.Print lngLastRow
End Sub





1 comment:

  1. I read Your Post and really its really Nice Article & Very Informative Post Otherwise if any One Want To Grow your Career in Advanced Excel So There are Some Top Best Training Center for excel & Advanced Excel institute

    Advanced excel course in Delhi
    Advanced excel course in Noida
    Advanced excel Training in Delhi
    Advanced excel Training in Noida

    ReplyDelete