Application.AlertBeforeOverwriting Property (Excel)
True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation. Read/write Boolean.
Syntax
expression .AlertBeforeOverwriting
expression A variable that represents an Application object.
Example
This example causes Microsoft Excel to display an alert before overwriting nonblank cells during drag-and-drop editing.
Application.AlertBeforeOverwriting = True