DragToRow Property

Applies To

PivotField object.

Description

True if the field can be dragged to the row position. The default value is True. Read/write Boolean.

See Also

DragToColumn property, DragToHide property, DragToPage property.

Example

This example prevents the Year field from being dragged to the row position.

Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Year").DragToRow = False