O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PivotField and PivotFields Members

Use the PivotFields collection to get fields from a pivot table. Use the PivotTable object’s PivotFields, PageFields, ColumnFields, RowFields, DataFields, or HiddenFields properties to get a reference to this collection. Use the PivotField object to set the layout of a pivot table, to filter and sort items, and to get the items in a field. The PivotFields collection and PivotField object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

AddPageItem

Application 2

AutoShow

AutoShowCount

AutoShowField

AutoShowRange

AutoShowType

AutoSort

AutoSortField

AutoSortOrder

BaseField

BaseItem

CalculatedItems

Calculation

Caption

ChildField

ChildItems

Count 1

Creator 2

CubeField

CurrentPage

CurrentPageList

CurrentPageName

DatabaseSort

DataRange

DataType

Delete

DragToColumn

DragToData

DragToHide

DragToPage

DragToRow

DrilledDown

EnableItemSelection

Formula

Function

GroupLevel

HiddenItems

HiddenItemsList

IsCalculated

IsMemberProperty

Item 1

LabelRange

LayoutBlankLine

LayoutForm

LayoutPageBreak

LayoutSubtotalLocation

MemoryUsed

Name

NumberFormat

Orientation

Parent 2

ParentField

ParentItems

PivotItems

Position

PropertyOrder

PropertyParentField

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required