AlertBeforeOverwriting Property

True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation. Read/write Boolean.

Example

This example causes Microsoft Excel to display an alert before overwriting nonblank cells during drag-and-drop editing.

Application.AlertBeforeOverwriting = True