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