Advertisement
Guest User

Untitled

a guest
Aug 31st, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. Sub AutoFilter_Copy()
  2. Dim DataSheet As Worksheet
  3. Application.ScreenUpdating = False
  4. '---------------------------------
  5. Set DataSheet = ActiveSheet
  6.  
  7. For i = 10 To 200
  8. DataSheet.Range("$A$1").AutoFilter Field:=1, _
  9. Criteria1:=i, _
  10. Operator:=xlAnd
  11.  
  12. If DataSheet.UsedRange.SpecialCells(xlCellTypeVisible).Count > 13 Then
  13. DataSheet.UsedRange.Copy
  14. Worksheets.Add After:=Worksheets(Worksheets.Count)
  15. Worksheets(Worksheets.Count).Paste
  16. DataSheet.Activate
  17. End If
  18. Next
  19. '---------------------------------
  20. Application.CutCopyMode = False
  21. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement