Hi,
I have two pivot tables which get updated daily by the source data worksheet. What I want to do is select and "tick" the current date for these two worksheets.
I have this code so far which doesn't work...
The error is in this lineSub Macro1() ' ' Macro1 Macro ' ' Dim TodayDate As Date TodayDate = Date Sheets(Array("Queue Trend", "Due Date Analysis Trend")).Select With ActiveSheet.PivotTables("PivotTable1").PivotFields("Date") .PivotItems(TodayDate).Visible = True End With End SubCan someone please help me with this? Do I need a for loop?.PivotItems(TodayDate).Visible = True
Thank you in advance