Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

  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...

Part and Inventory Search

Back
Top