| title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|---|
PivotTable.DrillTo method (Excel) |
vbaxl10.chm235208 |
|
9f700cba-2cf5-4b13-707f-254148ddf73a |
05/08/2019 |
medium |
Enables you to drill to a location within an OLAP-based or PowerPivot-based cube hierarchy.
expression.DrillTo (PivotItem, CubeField, PivotLine)
expression A variable that represents a PivotTable object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| PivotItem | Required | PIVOTITEM | The member from which the drill operation is performed. |
| CubeField | Required | CUBEFIELD | The target hierarchy being drilled to. |
| PivotLine | Optional | Variant | Specifies the line in the PivotTable where the operation starting member resides. In cases where PivotLine is not specified, defaults to the top PivotLine where the member appears. |
VOID
[!includeSupport and feedback]