Advertisement
Guest User

GUSTO

a guest
Mar 22nd, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Selection.Group Start:=True, End:=True, Periods:=Array(False, False, False, _
  2.         True, True, False, False)
  3.     ActiveSheet.PivotTables("Pivot").PivotFields("Months").ShowDetail = False
  4.     With ActiveSheet.PivotTables("Pivot").PivotFields("Months")
  5.         .PivotItems("<3/1/2017").Visible = False
  6.         .PivotItems("Jan").Visible = False
  7.         .PivotItems("Feb").Visible = False
  8.         .PivotItems("Apr").Visible = False
  9.         .PivotItems("May").Visible = False
  10.         .PivotItems("Jun").Visible = False
  11.         .PivotItems("Jul").Visible = False
  12.         .PivotItems("Aug").Visible = False
  13.         .PivotItems("Sep").Visible = False
  14.         .PivotItems("Oct").Visible = False
  15.         .PivotItems("Nov").Visible = False
  16.         .PivotItems("Dec").Visible = False
  17.         .PivotItems(">3/17/2017").Visible = False
  18.     End With
  19.     Range("A7").Select
  20.     ActiveSheet.PivotTables("Pivot").PivotFields("Months").PivotItems("Mar"). _
  21.         ShowDetail = True
  22. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement