Expand Minimize

PivotTable.MergeLabels Property (Excel)

True if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells. Read/write Boolean.

expression .MergeLabels

expression A variable that represents a PivotTable object.

This example causes the first PivotTable report on worksheet one to use merged-cell outer-row item, column item, subtotal, and grand total labels.

Worksheets(1).PivotTables(1).MergeLabels = True

Community Additions

ADD
Show:
© 2014 Microsoft