Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Application.ScreenUpdating = False
  2. Worksheets(ActiveSheet.Name).Select
  3. For Each r In Worksheets(ActiveSheet.Name).UsedRange.Rows
  4. n = r.Row
  5.  
  6. If n < 11 Then
  7. GoTo label
  8. End If
  9.  
  10. If r.EntireRow.Interior.ColorIndex <> 6 Then
  11. r.EntireRow.Delete
  12. End If
  13. label:
  14. Next r
  15. Application.ScreenUpdating = True
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement