Extract pivot table info

  • Thread starter Thread starter jaya
  • Start date Start date
J

jaya

Hi,

I have a pivot table which has filters in the page
fields. When the user selects the filters i want to
retrieve the filter information and store it for later
use. How do i do that using VBA?

-Jaya
 
For a pagefield, the filter would be the value showing.

? Activesheet.PivotTables(1).PageFields(1).CurrentPage
A

Regards,
Tom Ogilvy
 
I tried that and i get an error,

Unable to get the currentpage property of the pivottable
class. I am using excel2000.

-Jaya
 
Back
Top