Replaying a pivot table in a macro

Hello

I recorded a simple pivot table using a macro however when i try to repay it i get the error:

'Unable to get the pivot tables probperty of the worksheet class'

The debugger points at this line of code:

HTML Code: 

I renamed the pivot table so its not clashing with an already existing table and other then that i dont know or cant find out what to do. Any advice would be greatly appreciated.

Thanks a million

Please Login or Register  to view this content.

Thank you!!!!

Hi JR

I changed it to PivotTable6 and category is the name of the column that i want to construct the pivot table from.

Thanks again