LinkBack URL
About LinkBacks
Hello
could some one please advise why I'm getting a runtime 1004 error 'Unable to get the Pivotitems property of the Pivotfield class' in the following macro. Highlighted where it falls over:
Thank youHTML Code:
Hello
could some one please advise why I'm getting a runtime 1004 error 'Unable to get the Pivotitems property of the Pivotfield class' in the following macro. Highlighted where it falls over:
Thank youHTML Code:
Last edited by DavidBW; 01-27-2012 at 10:03 AM.
Try changing that line toIf this does not work, maybe you could explain what you would want to see in your pivot and then i can help you accordingly.
Please Login or Register to view this content.
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]
Unfortunately that didn't work.
I want to be able to limit the view in the "Month Left" pivot table field to the value found in range name "Pivot Month" in the "Cover" tab.
This macro works perfectly for another field (department). I think it may be to do with date formatting. I posed an earlier question (26/01) about Date Formatting within the row field of a pvot table which has yet to be solved "Date Format in Pivot table Row field (Excel 2003)".
Does it work if you change the formatting of this date filed to Number, then run the code?
OK, I've sorted the date formatting issue (the column header in the source data was formatted to mmm-yy whereas it should have been text) however that hasn't solved the problem originally posted in this thread.
Have tried different methods but still having same problem - any clues anyone?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks