Hello All,
Im trying to filter a specific date in a pivot table but im receiving "Application-deifned or object-defined error".
I tried to record macro and got the below output, but while i try to run the same recorded output again im getting the above mentioned error.
In sheet1 range("A5") i have a date and that should be applied in the pivot table. Can someone help me..
Im trying to filter a specific date in a pivot table but im receiving "Application-deifned or object-defined error".
I tried to record macro and got the below output, but while i try to run the same recorded output again im getting the above mentioned error.
VBA Code:
ActiveSheet.PivotTables("PivotTable4").PivotFields("Date"). _
ClearAllFilters
ActiveSheet.PivotTables("PivotTable4").PivotFields("Date"). _
CurrentPage = "9/18/2020"
In sheet1 range("A5") i have a date and that should be applied in the pivot table. Can someone help me..