This is pasted from the VBA help on the 'group' method. There is also the
AutoOutline Method, Outline Object, ClearOutline Method, DisplayOutline
Property, etc
The Range object must be a single cell in the PivotTable field’s data range.
If you attempt to apply this method to more than one cell, it will fail
(without displaying an error message).
Example
This example groups the field named ORDER_DATE by 10-day periods.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Set groupRange = pvtTable.PivotFields("ORDER_DATE").DataRange
groupRange.Cells(1).Group by:=10, _
periods:=Array(False, False, False, _
True, False, False, False)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
