In a pivot table, how do I pass the selected cell field values (ie the values of row & column data for the selected cell) to VBA? I just can't find the correct syntax... I think it's something like
ActiveCell.PivotField("fieldname").value but that doesn't work.
(In Access, I can use Me.PivotTable.ActiveObject.Cell.Recordset.Fields("fieldname").Value)
Have looked through VBA's locals window without success.
Thanks in advance.
Bookmarks