Range.Group(Object, Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

When the Range object represents a single cell in a PivotTable field’s data range, the Group method performs numeric or date-based grouping in that field.

public object Group (object Start, object End, object By, object Periods);

Public Function Group (Optional Start As Object, Optional End As Object, Optional By As Object, Optional Periods As Object) As Object

Parameters

Start: Object

Optional Object. The first value to be grouped. If this argument is omitted or True, the first value in the field is used.

End: Object

Optional Object. The last value to be grouped. If this argument is omitted or True, the last value in the field is used.

By: Object

Optional Object. If the field is numeric, this argument specifies the size of each group. If the field is a date, this argument specifies the number of days in each group if element 4 in the Periods array is True and all the other elements are False. Otherwise, this argument is ignored. If this argument is omitted, Microsoft Excel automatically chooses a default group size.

Periods: Object

Optional Object. An array of Boolean values that specify the period for the group, as shown in the following table.If an element in the array is True, a group is created for the corresponding time; if the element is False, no group is created. If the field isn’t a date field, this argument is ignored.

Returns

Object

Remarks

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 but will not display an error message.

Applies to