How to disable "There's already data here. Do you want to replace it?" warning

When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's already data here. Do you want to replace it?". How to disable it?

Warning Message

Disable "There's already data here." warning by built-in Settings

  1. Go to File > Options > Advanced > Editing options > Enable fill handle and cell drag-and-drop
  2. Un-check "Alert before overwriting cells"

Disable "There's already data here." warning by VBA

Sub DisableAlerts()
    Application.DisplayAlerts = False
    
    'Place your code here
    
    'After your code is finished, enable the alert mode again
    Application.DisplayAlerts = True
End Sub

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>

7 comments
  1. ST
    stevo

    Macro version worked! Thank you mate!

More comments