Selected Pivot Filters to a given Cell

[Saperblue56]

Hi all, Im Ray
I Have a Question todo with Piviot & VBA (Excel 2007)
is it Possable to read the Chosen Filters in a Pivot Table, and write them to a given Cell?

All Help appreacheated

Ray

 

[Saperblue56]

Well Hello once again
this does not seam to work, so I will try another aproach!

Is it Possable to Access the Filters in a Pivot Table?
if yes please explain how & how I can write the Selected Filters to a given cell (as an Array please)

Hopefully

Ray

 

[Saperblue56]

Hi,
I Found the Answer!
VBA to Find Pivot Table Filters

Many thanks to RoryA for this

Ray