Microsoft Office Tutorials and References
In Depth Information
20.5.1.2 DataFields property
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.2 DataFields property
This property returns the collection of all data fields, using the syntax:
PivotTableObject .DataFields
Alternatively, we can return selected data fields using the syntax:
PivotTableObject .DataFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.3 HiddenFields property
As we will see, a pivot field can be hidden by setting its orientation to xlHidden . The
HiddenFields property returns the collection of all hidden fields, using the syntax:
PivotTableObject .HiddenFields
Alternatively, we can return selected hidden fields using the syntax:
PivotTableObject .HiddenFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.4 PageFields property
The PageFields property returns the collection of all page fields, using the syntax:
PivotTableObject .PageFields
Alternatively, we can return selected page fields using the syntax:
PivotTableObject .PageFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.5 PivotFields property
The PivotFields property returns the collection of all pivot fields, using the syntax:
PivotTableObject .PivotFields
Alternatively, we can return selected pivot fields using the syntax:
PivotTableObject .PivotFields( Index )
where Index is either a single index (the index number of the desired field) or an array of indexes.
20.5.1.6 RowFields property
Search JabSto ::




Custom Search