Unable to set the CurrentPage Property of the PivotField Class

Hi All,

Im Trying to Automate my Pivot Tables through VBA.

i want the report filter field in the pivottable to automotically select the value from Comobobox.

and i get "Unable to set the CurrentPage Property of the PivotField Class" error while running the code.


please help

Murali

Any help on this? I am having the same issue. I followed the instructions on:

http://www.datapigtechnologies.com/f...s/pivot10.html

and can't seem to get it to work.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.