I have a procedure that copies data from a data base to a template sheet and then make a copy of the sheet which inserted at a particular point in the workbook. I say have in that it works for about 20 of the sheets that I want to copy and then stalls with the above message.

The code where it stalls at the second of the undernoted lines.

Application.DisplayAlerts = False
Sheets("Standard tenancy data").Copy Befo=Sheets("EndTenancies")
Application.DisplayAlerts = True

Any idea why this might be happening?
--
TIA
Ron