PivotLine.Find Method
The Find method returns a PivotLine object if one matches the supplied arguments or a run-time error if no PivotLine matches.
Version Information
Version Added: Excel
Syntax
expression.Find(FieldOrItem1, FieldOrItem2, FieldOrItem3, FieldOrItem4, FieldOrItem5, FieldOrItem6, FieldOrItem7, FieldOrItem8, FieldOrItem9, FieldOrItem10, FieldOrItem11, FieldOrItem12, FieldOrItem13, FieldOrItem14, FieldOrItem15, FieldOrItem16, FieldOrItem17, FieldOrItem18, FieldOrItem19, FieldOrItem20, FieldOrItem21, FieldOrItem22, FieldOrItem23, FieldOrItem24, FieldOrItem25, FieldOrItem26, FieldOrItem27, FieldOrItem28, FieldOrItem29, FieldOrItem30)
expression A variable that represents a PivotLine object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| FieldOrItem1 | Optional | Variant | Field/Item 1 |
| FieldOrItem2 | Optional | Variant | Field/Item 2 |
| FieldOrItem3 | Optional | Variant | Field/Item 3 |
| FieldOrItem4 | Optional | Variant | Field/Item4 |
| FieldOrItem5 | Optional | Variant | Field/Item 5 |
| FieldOrItem6 | Optional | Variant | Field/Item 6 |
| FieldOrItem7 | Optional | Variant | Field/Item 7 |
| FieldOrItem8 | Optional | Variant | Field/Item 8 |
| FieldOrItem9 | Optional | Variant | Field/Item 9 |
| FieldOrItem10 | Optional | Variant | Field/Item 10 |
| FieldOrItem11 | Optional | Variant | Field/Item 11 |
| FieldOrItem12 | Optional | Variant | Field/Item 12 |
| FieldOrItem13 | Optional | Variant | Field/Item 13 |
| FieldOrItem14 | Optional | Variant | Field/Item 14 |
| FieldOrItem15 | Optional | Variant | Field/Item 15 |
| FieldOrItem16 | Optional | Variant | Field/Item 16 |
| FieldOrItem17 | Optional | Variant | Field/Item 17 |
| FieldOrItem18 | Optional | Variant | Field/Item 18 |
| FieldOrItem19 | Optional | Variant | Field/Item 19 |
| FieldOrItem20 | Optional | Variant | Field/Item 20 |
| FieldOrItem21 | Optional | Variant | Field/Item 21 |
| FieldOrItem22 | Optional | Variant | Field/Item 22 |
| FieldOrItem23 | Optional | Variant | Field/Item 23 |
| FieldOrItem24 | Optional | Variant | Field/Item 24 |
| FieldOrItem25 | Optional | Variant | Field/Item 25 |
| FieldOrItem26 | Optional | Variant | Field/Item 26 |
| FieldOrItem27 | Optional | Variant | Field/Item 27 |
| FieldOrItem28 | Optional | Variant | Field/Item 28 |
| FieldOrItem29 | Optional | Variant | Field/Item 29 |
| FieldOrItem30 | Optional | Variant | Field/Item 30 |
Return Value
PivotLine
Remarks
The arguments can be supplied in random order but the lines have to be fully qualified; all PivotItems in the PivotLine have to be supplied as arguments to the Find method for a line to be found.
The ItemName arguments are all optional.
The ItemName arguments can be: PivotItem object, PivotField object, String, or an array of one of these objects.