M
Mike Swintosky
I recorded a macro to find out the syntax for choosing
which page in a pivot table I wish to look at:
ActiveSheet.PivotTables("PivotTable6").PivotFields
("Name").CurrentPage = "MIKE"
Now I would like to obtain a listing of all the pages in
that pivot table. Does anyone know how to get that list
of values? I will be using that list to create a separate
dropdown control. Selecting values from the dropdown
control will feed a macro which will set the pivot table
to the desired page, etc., etc.
which page in a pivot table I wish to look at:
ActiveSheet.PivotTables("PivotTable6").PivotFields
("Name").CurrentPage = "MIKE"
Now I would like to obtain a listing of all the pages in
that pivot table. Does anyone know how to get that list
of values? I will be using that list to create a separate
dropdown control. Selecting values from the dropdown
control will feed a macro which will set the pivot table
to the desired page, etc., etc.