Extract pivot table info

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
 
T

Tom Ogilvy

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

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

Regards,
Tom Ogilvy
 
J

jaya

I tried that and i get an error,

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

-Jaya
 
Top