line is pc.CreatePivotTable TableDestination:="", TableName:="pivottable2"

error is Run-time error '1004': Application-defined or object-defined error
....

thanks for your help.

Ele

"Bill Manville" wrote in message
...
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