Problem in paste - Run time error 1004

Hello Friends

Please find the attached 2010 version file (Problem in paste Run time error 1004.xlsm)

While running the macro it shows the folowing error

Run-time error `1004':
Paste method of Worksheet class failed

at Sheets("Output").Paste in the VBA code

Please help me to rectify this issue.

thanks in advance

I cannot replicate the error. It works for me. Excel 2013.

Takes a long time to run but no error either. Excel 2007

Hello Friends

Thanks to all friends who tested my file.

I also noticed this file is working in Windows 7 8 GB RAM Excel 2010 but not working and creating the error message
in Windows 8.1 pro 2 GB RAM same Excel 2010.

By using below procedure i changed the priority to `Realtime' from default `Normal' and now Excel producing
the charts per VBA code without producing the errors.

Thanks again to all friends who tested my file.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MS Excel memory increase :
Winodws 8.1 Pro to MS Excel 2010 Memory increase.

Open Excel 2010, go to `Task Manager'
Select `Microsoft Excel' in `Apps' area
`Task Manager' > `Details' tab,
Select `EXCEL.EXE' > right click > Set priority >
Change deafult `Normal' to `Realtime'.
Confirmation `Do you want to change the priority of `EXCEL.EXE'
Click `Change Priority'.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Glad it works now and thanks for the rep.

Well, that's a new one for me. I have to keep this in mind. Thanks for reporting.

I had a similar issue in the past where I copied a file and then opened it for the purpose of deleting, hiding and locking sheets for a final user report. It worked sometimes and failed others. I had to add a DoEvent to let the code to copy the file complete before trying to open it.