Occurs when a user starts to drag the selected cell range.
public event BeforeDragRangeEventHandler BeforeDragRange
Public Event BeforeDragRange As BeforeDragRangeEventHandler
The BeforeDragRange event's data class is BeforeDragRangeEventArgs. The following properties provide information specific to this event:
|Cancel||Gets or sets whether to cancel the drag-and-drop or fill operation for the selected cell range.|
|DataTransferMode||Returns the operation type a user performs on the selected cells.|
|Range||Returns a cell range a user starts to drag.|
Handle the BeforeDragRange event to perform any actions when a user starts to drag a cell range in a worksheet. This event occurs first in a sequence of events related to the drag-and-drop and fill operations.
The following table lists events that can fire depending on the operation type (DataTransferMode):
Set the event’s Cancel parameter to true to cancel the drag operation.