How to retrieve the context information of a cell in a pivot?

[marser]

Hi all,

I would like to get the "active field" information of a cell in a pivot table. Any idea how to get the information via formula or VBA?

Many thanks,

Marser

[judgeh59]

if you are talking about "active field" being the same as active cell - then there is an object in VBA called activecell.XXXX....so it would be activecell.value or activecell.text. either should return the contents of the active cell...although I would probably use activecell.value....HTH