Expand Minimize

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.

expression .AlertBeforeOverwriting

expression A variable that represents an Application object.

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

Application.AlertBeforeOverwriting = True
Show:
© 2015 Microsoft