View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tama Tama is offline
external usenet poster
 
Posts: 2
Default How to find the current pagefield of a pivot table?

Hi,

When selecting a pivot item from a pagefield of a pivot table, how can one
programmatically get the name of the page field without having to know the
name of the page field?

My problem is this: I have 4 pivot charts on a worksheet having the same
page, row and column fields. (They only differ in Data fields). I am trying
to implement in VBA the behaviour that when a page field is changed in one
chart the same page fields are automatically changed in the other 3 charts.

Thanks
Tama