MsgBox "The quantity of chairs in the warehouse is: " & rngTableItem.Value PivotTable.GetPivotData("Quantity", "Warehouse", "Chairs") ' Get PivotData for the quantity of chairs in the warehouse. Also, this example assumes that, in the report, the title of the data field is Quantity, a field titled Warehouse exists, and a data item titled Chairs exists in the Warehouse field. This example assumes that a PivotTable report exists on the active worksheet. In this example, Microsoft Excel returns the quantity of chairs in the warehouse to the user. The name of a column or row field in the PivotTable report. The name of the field containing the data for the PivotTable. GetPivotData ( DataField, Field1, Item1, Field2, Item2, Field3, Item3, Field4, Item4, Field5, Item5, Field6, Item6, Field7, Item7, Field8, Item8, Field9, Item9, Field10, Item10, Field11, Item11, Field12, Item12, Field13, Item13, Field14, Item14)Įxpression A variable that represents a PivotTable object. Returns a Range object with information about a data item in a PivotTable report.
0 Comments
Leave a Reply. |