Hi All,
I have run into an error in creating a pivot table. The error says object required, but I believe that I already have an object there. I'm sure this will be easy for the wiz' out there! The error occurs after the pivot table is created and where I start the "with PT." Thanks!
samplewb.xlsm
Please Login or Register to view this content.
Last edited by tlinton; 06-12-2012 at 10:44 AM.
You don't say where the error occurs.
And it would be good to have a sample of the workbook which exhibits the problem.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Okay, I have added the file and where it errors. Thanks for your help and sorry I forgot some useful info!
Whoops!!! You are going to need to run the Remove breakdown macro first!! In order for the macro i am having issues with to work properly
Okay, now you can run the Pivot code with out running the breakdown code. Sorry for the many posts. Dont know how to delete the old ones. Thanks
should be
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Jeepers!! I can't believe I didn't see that!! Thanks a lot Joseph!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks