Hi all,

I'm trying to run a macro that copies some data from one worksheet to 50 other worksheets using some specific criterias. While the macro copies everything correctly for around half of the data it stops after that and gives me the following error messages:

"Excel cannot complete this task with available resources. Choose less data or close other applications"

In the VBE it gives me:

"Run-time error 1004: Paste method of worksheet class has failed".

Then when I close Excel after these messages:

"The picture is too large and will be truncated".

Has anyone experienced something like that before? I don't have any other applications open and I don't think that this simple procedure should cause any problems with Excel. It's really strange.

Any help is greatly appreciated!!!!

Manuel