Application.AlertBeforeOverwriting Property

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

See Also

• Application Object
• Application Object Members