G
Guest
Hi All,
I'm writing some code that automatically changes PageField Values in a
PivotTable. On one of them, I get a Run Time Error 1004 "Unable to set the
_Default property of the PivotItem Class".
Does anyone know what this means in this context? Below is a section of code
that I'm using, and it works ok on another field that I am doing it on...
ActiveSheet.PivotTables("PivotTable1").PivotFields("Wk_Ending").CurrentPage
= _
"07/07/2007"
I'm writing some code that automatically changes PageField Values in a
PivotTable. On one of them, I get a Run Time Error 1004 "Unable to set the
_Default property of the PivotItem Class".
Does anyone know what this means in this context? Below is a section of code
that I'm using, and it works ok on another field that I am doing it on...
ActiveSheet.PivotTables("PivotTable1").PivotFields("Wk_Ending").CurrentPage
= _
"07/07/2007"