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
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
ReplyDeleteAdvanced excel course in Delhi
Advanced excel course in Noida
Advanced excel Training in Delhi
Advanced excel Training in Noida