AlertBeforeOverwriting Property Example
This example causes Microsoft Excel to display an alert before overwriting nonblank cells during drag-and-drop editing.
Application.AlertBeforeOverwriting = True