DragOff Method

         Example         Applies To

Drags a page break out of the print area.

Syntax

expression.DragOff(Direction, RegionIndex)

expression   Required. An expression that returns an HPageBreak or VPageBreak object.

Direction   Required Long. The direction in which the page break is dragged. Can be one of the following XlDirection constants: xlDown, xlToLeft, xlToRight, or xlUp.

RegionIndex   Required Long. The print-area region index for the page break (the region where the mouse pointer is located when the mouse button is pressed if the user drags the page break). If the print area is contiguous, there’s only one print region. If the print area is discontiguous, there’s more than one print region.

Remarks

This method exists primarily for the macro recorder. You can use the Delete method to delete a page break in Visual Basic.