Ron,

See if you can find something in these...

http://support.microsoft.com/?kbid=210684
Xl2000: Copying Worksheet Programmatically Causes Run-Time Error 1004
http://support.microsoft.com/?kbid=177634
Xl97: Copy Method Of Sheets Object Causes Invalid Page Fault

Regards,
Jim Cone
San Francisco, CA

"Ron McCormick" wrote in message ...
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