Range.ShowDetail (Excel)

True if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. Read/write Variant.

This property isn't available for OLAP data sources. If the specified range isn't in a PivotTable report, the following statements are true:

ActiveCell.ShowDetail = True