Place this line before the line which merges:Application.DisplayAlerts = FalseIt is recommended to place this next line after the merging iscomplete:Application.DisplayAlerts = Truesince the the first line disables _all_ alerts.