DragOff Method [Excel 2003 VBA Language Reference]

  • Article

Drags a page break out of the print area.

expression.DragOff(Direction, RegionIndex)

expression Required. An expression that returns one of the objects in the Applies To list.

XlDirection

XlDirection can be one of these XlDirection constants.
xlDown
xlToRight
xlToLeft
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.

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

Applies to | HPageBreak Object | VPageBreak Object