HI All
I have created a Macro for Pivot Tables and when am trying to apply the same code in different sheet its showing the run time error 1004.
Can someone please check the below code and let me know if any changes to be made also if possible can someone make changes to it.
Please Login or Register to view this content.
Which line is highlighted in yellow when you get the error?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
It is getting stuck at below,
Please Login or Register to view this content.
Hi All,
Can someone help me for the above please.
Thanks & Regards,
Srikanth
The problem with this sort of code is always related to the setting of the source data range or the location of the new pivot table.
http://support.microsoft.com/kb/940166/en-us
Maybe try emptying TableDestination, as in TableDestination = "" instead of what you have now.
I have one that works which I made a while ago, it goes like this:
Please Login or Register to view this content.
Last edited by Pichingualas; 04-23-2012 at 09:03 AM.
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
Hi ,
Thanks for the information.
Am very new to VBA, could you please help me by editing my code and past it again so that i can use it.
Thanks,
Ben
Try with this:
If this still doesn't work, please check your data: make sure the first row of it (the headers) doesn't have any empty fields, which can also be a reason for your code crashing. Anyway, I hope it helps.Please Login or Register to view this content.
Last edited by Pichingualas; 04-23-2012 at 12:05 PM. Reason: minor change in code
Hi,
Thanks for the above Code, I did check the "Header" and it does not have any "Empty" header or field, however the macro stopping at
Please Login or Register to view this content.
Hi,
Could you please help me for the above.
Regards,
Srikanth
I'll look in to it, sorry for the delay.
Sorry Srikanth, it works fine on this computer with excel 2007. I'll try on excel 2003 later on, don't have it at hand at the moment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks