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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Storing Multiple Selected Pivot Table Report Filter Values 2
Get visible pivot table items 4
Corrupt files due to pivot remnants after saving via VBA 0
change pivot table in code 3
Using VBA on Excel Pivot Tables 3
Pivot Page field filter based on cell value 6
Help list box to update pivot table 1
Excel Pivot Table - Get data in Pivot Field 0

Back
Top