Hello friends, hope all is well!
please see the image in which shows the code, the code runs on the cell value of F1. and that should change the result of the pivottable.
I got this error message: "run-time error 1004 Unable to get the PivotFields property of the PivotTable Class".
please tell me what I should to correct the code.
Thank you very much in advance!
First of all, I highly recommend putting Option Explicit as the first line in the module. This will force you to declare the variables. It is good coding practice.
Secondly, I recommend attaching a sample workbook. I don't see anything offhand that would cause the error, but there is a lot that I cannot see in pictures alone.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
hello there! ok here is the attachment. your kind help is needed and appreciated.
please help fix the code.
Based on the other code in your file, it seems you're using the data model, so you should use PivotFields("[Range].[CITY].[CITY]") instead.
ok sure, but can you please adjust the code. I am curious why it didn't work.
You may want to update your profile too as it appears you aren't using Excel 2010.
Please Login or Register to view this content.
profile updated. and made the suggested change, however, I got another error. the following line is in yellow:
Field.CurrentPage = Stng
Please Login or Register to view this content.
I can't test since I only have 2010 here, but try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks