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
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