Creating a PivotTable in VBA Failing

Hi there, I'm having a little bit of trouble creating a pivot table using VBA, and not sure why, given that I'm doing it as part of a function that's working fine on a different project and being called in exactly the same way?

The macro fails on the

Please Login or Register  to view this content.

step
with the error message: Method 'Add' of object 'PivotCaches' failed. I get a similar message if I try pivotcaches.create.
any help would be much appreciated.
here's the function:

Please Login or Register  to view this content.