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?
Disable "There's already data here." warning by built-in Settings
- Go to File > Options > Advanced > Editing options > Enable fill handle and cell drag-and-drop
- 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