Hi Paul,

Thanks for your help.

I tried your code and it only worked on the first PT in the worksheet, which is PivotTable49.

Regards,

greg