Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. Dim i As Integer
  2. Dim MemberID As String
  3.  
  4. Application.ScreenUpdating = False
  5.  
  6. ThisWorkbook.SlicerCaches("Slicer1").ClearManualFilter
  7.  
  8. 'Deselect all prior set values
  9. For Each slc In ThisWorkbook.SlicerCaches("Slicer1").SlicerItems
  10. slc.Selected = False
  11. Next slc
  12.  
  13. 'Select values in Slicer based on Top 10 Priority List
  14. For i = 1 To 10
  15. ID = ThisWorkbook.Worksheets("Summary").Range("A" & 57 + i).Value
  16. ThisWorkbook.SlicerCaches("Slicer1").SlicerItems(ID).Selected = True
  17. Next i
  18.  
  19. Application.ScreenUpdating = True
  20.  
  21. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement