Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
For i = 2 To Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row If i = 1 Then i = 2 End If For j = 1 To 55 If j = 7 Then GoTo nxt1 End If If Cells(i, j).Value <> "" Then Rows(i).Delete i = i - 1 GoTo nxt2 End If nxt1: Next j nxt2: Next i
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.