Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MyNameIsNeo

  1. MyNameIsNeo

    Referencing Rows to delete blank Rows

    You can also try this to delete all the empty rows in the used portion of a spreadsheet. Sub DeleteEmptyRows() LastRow = ActiveSheet.UsedRange.column - 1 + ActiveSheet.UsedRange.Rows.Count For r = LastRow To 1 Step -1 If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete...
See more

Part and Inventory Search

Back
Top Bottom