|Excel Developer Reference|
expression A variable that represents a Range object.
If the active cell is in a field header of a parent field, all the groups in that field are ungrouped and the field is removed from the PivotTable report. When the last group in a parent field is ungrouped, the entire field is removed from the report.
This example ungroups the ORDER_DATE field.
|Visual Basic for Applications|