Occurs after a cell range was automatically filled with data based on values in the source range.
public event AfterFillRangeEventHandler AfterFillRange
Public Event AfterFillRange As AfterFillRangeEventHandler
The AfterFillRange event's data class is AfterFillRangeEventArgs. The following properties provide information specific to this event:
|OperationType||Gets the type of the fill operation a user performed over a cell range.|
|SourceRange||Returns a cell range based on which a user filled cells in the target range.|
|TargetRange||Returns a cell range that a user filled with data.|
Handle the AfterFillRange event to perform any actions after the AutoFill operation was performed for cells. This event allows you to obtain the source and resulting ranges, and determine whether a user copied source cells or filled cells with data based on values in the source range.
To cancel the fill operation for a cell range, handle the SpreadsheetControl.BeforeFillRange event and set its Cancel parameter to true.