ShowDetail Property

Applies To

PivotItem object, Range object.

Description

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.

For the PivotItem object (or the Range object if the range is in a PivotTable), this property is True if the pivot item is showing detail.

Remarks

If the specified range isn't in a PivotTable, the following remarks apply:

  • The range must be in a single summary row or column.
  • This property returns False if any of the children of the row or column are hidden.
  • Setting this property to True is equivalent to unhiding all the children of the summary row or column.
  • Setting this property to False is equivalent to hiding all the children of the summary row or column.
If the specified range is in a PivotTable, it's possible to set this property for more than one cell at a time if the range is contiguous. This property can be returned only if the range is a single cell.

See Also

ApplyOutlineStyles method, AutoOutline method, ClearOutline method, DisplayOutline property, Group method, Outline object, OutlineLevel property, Ungroup method (Range object).

Example

This example shows detail for the summary row of an outline on Sheet1. Before running this example, create a simple outline that contains a single summary row, and then collapse the outline so that only the summary row is showing. Select one of the cells in the summary row, and then run the example.

Worksheets("Sheet1").Activate
Set myRange = ActiveCell.CurrentRegion
lastRow = myRange.Rows.Count
myRange.Rows(lastRow).ShowDetail = True