PivotTable Error 1004

[paugleza]

I have a database, where I later made a dynamic table in which I have a column with the weeks of the year...

When I record a macro the following code is saved....

ActiveSheet.PivotTables("OVERALL").PivotFields("WEEK").ClearAllFilters
ActiveSheet.PivotTables("OVERALL").PivotFields("WEEK").CurrentPage = "19"

So if I try to run the macro again, an error occurs ( 1004, undefined application or objetc)

What can be?

 

[DanteAmor]

Hi and welcome to MrExcel.

You must ensure that the value 19 exists in the data of the "WEEK" field.

And the "WEEK" field is checked to display in the Report Filter area.