Edit

Share via

PivotField.LayoutBlankLine property (Excel)

  • Article

True if a blank row is inserted after the specified row field in a PivotTable report. The default value is False. Read/write Boolean.

Syntax

expression.LayoutBlankLine

expression A variable that represents a PivotField object.

Remarks

You can set this property for any PivotTable field; however, the blank row appears only if the specified field is a row field other than the innermost (lowest-level) row field.

For non-OLAP data sources, the value of this property doesn't change when the field is rearranged or added to the PivotTable report.

You cannot enter data in the blank row in the PivotTable report.

Example

This example adds a blank line after the state field in the first PivotTable report on the active worksheet.

With ActiveSheet.PivotTables("PivotTable1") _ 
 .PivotFields("state") 
 .LayoutBlankLine = True 
End With

**

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.