I’m trying to use the VB capabilities of Excel to extract the drill-down contents of a single sell within a pivot table and dump the tabular data onto a worksheet of my choosing. While it is possible to drill down using the Excel GUI, the results end up in a separate worksheet, which is not what I want.

Alternatively, if there is a programmatic way to access the tabular contents of a specific pivot table’s cell, that would work too. Of course one would have to be able to determine what the cell contained (content, or a reference to content). Either way, thanks in advance.

-Darren-