HPageBreak.DragOff method (Excel)
Drags a page break out of the print area.
Syntax
expression.DragOff (Direction, RegionIndex)
expression A variable that represents an HPageBreak object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Direction | Required | XlDirection | The direction in which the page break is dragged. |
| 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. Use the Delete method to delete a page break in Visual Basic.
Example
This example deletes vertical page break one from the active sheet by dragging it off the right edge of print region one.
ActiveSheet.VPageBreaks(1).DragOff xlToRight, 1
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.