Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. Sub proDelete()
  2.  
  3. Do Until (Selection.Value = 44 Or Selection.Row = 2)
  4. If Selection.Value = "" Then
  5. Selection.EntireRow.Delete
  6. Else
  7. Selection.Offset(1, 0).Select
  8. End If
  9. Loop
  10.  
  11. Range("A1").Select
  12.  
  13. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement