Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub HKiller()
- For i = 451 To 12 Step -1
- If Cells(i, "H").Value = 0 Then Rows(i).Delete
- Next i
- End Sub
- Sub test()
- Dim Lastrow As Long, i As Long
- 'LastColumn = .Cells(1, .Columns.Count).End(xlToLeft).Column
- With ThisWorkbook.Worksheets("Sheet1")
- Lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
- For i = 0 To Lastrow Step 1
- If Cells(i, "E" Or "F").Value = 0 Then Rows(i).Delete
- Lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row
- Next i
- End With
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement