Capturing contextual tooltip data

[mikecj]

Everyone,

I have a pivot table. When I select a cell the contextual tooltip data displays all the row and column information that feeds that particular cell. Is there a method to capture that data string?

The pivot table goes four levels deep. From any given cell, we have:
cell> cell's parent> cell's grandparent> cell's great granparent. So you can see that capturing the string would preferable to manipulating the child/parent relationship for each pair.

Thanks,

MikeCJ