Skip to content

Latest commit

 

History

History
43 lines (25 loc) · 1023 Bytes

Excel.PivotTable.InnerDetail.md

File metadata and controls

43 lines (25 loc) · 1023 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
PivotTable.InnerDetail property (Excel)
vbaxl10.chm235084
vbaxl10.chm235084
Excel.PivotTable.InnerDetail
385449ab-fbe2-8b69-374e-a5d374a3f76f
05/08/2019
medium

PivotTable.InnerDetail property (Excel)

Returns or sets the name of the field that will be shown as detail when the ShowDetail property is True for the innermost row or column field. Read/write String.

Syntax

expression.InnerDetail

expression A variable that represents a PivotTable object.

Remarks

This property isn't available for OLAP data sources.

Example

This example displays the name of the field that will be shown as detail when the ShowDetail property is True for the innermost row field or column field.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
MsgBox pvtTable.InnerDetail

[!includeSupport and feedback]