Pivot table giving 'runtime error 1004'

[wantucce]

I am running a macro that creates a pivot table and it seems to work ok if I can choose the cells to run the pivot table on. It is not possible to set up a default as the report changes in rows but not in columns. When I record using all cells, I get an error of 'runtime error 1004'
Unable to get the pivot table property of the pivot table class.
Seems to me that it almost needs to pause to let the pivot function catch up with the rest of macro.
Here is the code inside the debugger

Please Login or Register  to view this content.

Any help would be greatly appreciated.