Hello,

I'm trying to create a pivot table using vba with some instructions from an Excel help book.

Formula: copy to clipboard 
Please Login or Register  to view this content.


My code is getting as far as ' Create the cache ' and then run time error 1004 application-defined or object defined error.

Any ideas?