Thanks in advance, BTW!
----------------------------------------
Here's the code I'm trying to run:
WalkDate = Worksheets("Print Me!").Range("DateChoice").Text
' WalkDate is cell F3
'
ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").PivotItems("Show All").Visible = False
Worksheets("Print Me!").PivotTables("PivotTable1").PivotFields("Date").PivotItems(WalkDate).Visible = True
What I'm wanting is for the Pivot Table to filter by no date fields and then filter only by the field set in cell F3 (WalkDate).
Does this make sense? I'm getting an error message stating "Run-time error '1004': Unable to get the PivotItems property of the PivotField class"
----------------------------------------
Here's the code I'm trying to run:
WalkDate = Worksheets("Print Me!").Range("DateChoice").Text
' WalkDate is cell F3
'
ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").PivotItems("Show All").Visible = False
Worksheets("Print Me!").PivotTables("PivotTable1").PivotFields("Date").PivotItems(WalkDate).Visible = True
What I'm wanting is for the Pivot Table to filter by no date fields and then filter only by the field set in cell F3 (WalkDate).
Does this make sense? I'm getting an error message stating "Run-time error '1004': Unable to get the PivotItems property of the PivotField class"