Eric Lecocq wrote:
the following code works perfect till thre comment pivot table 2
i receive an error invalid call or reference


On what line is the error reported?
I don't recognise the error message - what error number and what
precise wording?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup