Function SetFilterOfMonth(yr, mon) mFilter = "&[" & yr & "].&[" & mon & "]" ActiveSheet.PivotTables("PivotTable3").PivotFields( _ "[CS Date].[CS Date Hierarchy].[CS Year]" _ ).VisibleItemsList = Array("") ActiveSheet.PivotTables("PivotTable3").PivotFields( _ "[CS Date].[CS Date Hierarchy].[CS Month]" _ ).VisibleItemsList = Array( _ "[CS Date].[CS Date Hierarchy].[CS Year]." & mFilter _ ) End Function Sub Test() mYear = Worksheets("Sheet1").Range("B8") mMonth = Worksheets("Sheet1").Range("B9") SetFilterOfMonth mYear, mMonth End Sub