RemoveFieldSet Method

Microsoft Office Web Components Visual Basic

Removes a field set from the specified axis.

expression.RemoveFieldSet(FieldSet)

expression    An expression that returns a PivotDataAxis , PivotFilterAxis , or PivotGroupAxis object.

FieldSet    Required Variant. Specifies the field set to be removed. Can be a PivotFieldSet object, a field set name, or a field set index number.

Example

This example removes the ShipVia field from the filter axis in PivotTable1.

PivotTable1.ActiveView.FilterAxis.RemoveFieldSet "ShipVia"