|Excel Developer Reference|
expression A variable that represents a Range object.
This property isn’t available for OLAP data sources.
If the specified range isn’t in a PivotTable report, the following statements are true:
- 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 report, 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.
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.
|Visual Basic for Applications|