Edit

PivotTable.InGridDropZones property (Excel)

  • Article

This property is used to toggle in-grid drop zones for a PivotTable object. In some cases, it also affects the layout of the PivotTable. Read/write Boolean.

Syntax

expression.InGridDropZones

expression A variable that represents a PivotTable object.

Remarks

When the InGridDropZones property is set to True, there are in-grid drop zones. When the property is set to False, there are no in-grid drop zones.

The PivotTable layout also changes with this property.

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.