How to get pivot cell source range?

If I double click on a data cell in a pivot a sheet is created with the relevant source records (rows). How do I programmatically establish the source range from the pivotcell object? I have monkeyed with all sorts of things to no avail. Hopefully there is a simple solution.

Regards, AB

There seems to be lots of pivot objects in the reference documentation, and also lots of methods to go with them. Not sure if what you are looking for is there. I once set up a sheet with a pivot that extracted rows when you double clicked on a datapoint. I made sure the first column of the underlying table had a unique reference line number, and then I used the find function to go to identify that line in the underlying table. Not sure if that helps or not.

Matt

I can write code to find the referenced rows associated with a data point using a key field in the pivot. However, I was hoping that there would be a method that would return the row range(s) so I could avoid having to do this. Excel appears to "know" where the referenced rows are since it responds instantly to double click on a data cell. I have not been able to find a way of accessing this knowledge other than writing my own code.

Regards, AB