ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I would like to have the filter in my pivot table change each week to the current Week Number which I have calculated using Named Range "WeekNumber"
I tried the following code but get an error.
I tried the following code but get an error.
VBA Code:
Dim PTName As String
PTName = [WeekNumber]
ActiveSheet.PivotTables("Sales").PivotFields("[Date Typed].[Week]") _
.CurrentPageName = PTName