Advertisement
Guest User

Untitled

a guest
Apr 17th, 2014
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. Dim SearchCell As Range
  2. Dim SearchTerm As Variant
  3. Sheets("Air").Select
  4. Range("A3").Select
  5. Do
  6. SearchTerm = ActiveCell.Value
  7. Sheets("Mixed").Select
  8. Columns("A").Select
  9. Set SearchCell = Cells.Find(What:=SearchTerm)
  10.  
  11. If SearchCell Is Nothing Then
  12. Sheets("Air").Select
  13. ActiveCell.Offset(1, 0).Select
  14. Else
  15. Cells.Find(What:=SearchTerm).Activate
  16. ActiveCell.EntireRow.Select
  17. Selection.Delete Shift:=xlUp
  18. Sheets("Air").Select
  19. ActiveCell.Offset(1, 0).Select
  20. End If
  21.  
  22. Loop Until ActiveCell.Value = ""
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement