B
beanbrain
I'm attempting to write VBA code to determine value for different pivot
table fields based on selected cells. For example, in a pivot table
that has product and manufacturing location as rows and months as
columns, I want to identify which product, which location and which
month belong to the current cell selection.
It seems to me that
Activesheet.Pivottables("PivotTable1").pivotfield("Product").PivotItem.name
should work, but it doesn't.
BeanBrain
table fields based on selected cells. For example, in a pivot table
that has product and manufacturing location as rows and months as
columns, I want to identify which product, which location and which
month belong to the current cell selection.
It seems to me that
Activesheet.Pivottables("PivotTable1").pivotfield("Product").PivotItem.name
should work, but it doesn't.
BeanBrain