HPageBreak.DragOff(XlDirection, Int32) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Drags a page break out of the print area.

public:
 void DragOff(Microsoft::Office::Interop::Excel::XlDirection Direction, int RegionIndex);

public void DragOff (Microsoft.Office.Interop.Excel.XlDirection Direction, int RegionIndex);

Public Sub DragOff (Direction As XlDirection, RegionIndex As Integer)

Parameters

Direction: XlDirection

Required XlDirection. The direction in which the page break is dragged. XlDirection can be one of these constants:xlDownxlToRightxlToLeftxlUp

RegionIndex: Int32

Required Integer. 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 noncontiguous, 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 programmatically.

Applies to