Export (0) Print
Expand All

PivotItems.Add Method

Office 2007
Creates a new PivotTable item.

Syntax

expression.Add(Name)

expression   A variable that represents a PivotItems object.

Parameters

NameRequired/OptionalData TypeDescription
NameRequiredStringThe name of the new PivotTable item.

Example

This example creates a new PivotTable item in the first PivotTable report on worksheet one.

Visual Basic for Applications
Worksheets(1).PivotTables(1).PivotItems("Year").Add "1998"



Community Additions

ADD
Show:
© 2015 Microsoft